Double sets of PostgreSQL?
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jun 2009
    Posts
    9

    Default Double sets of PostgreSQL?

    I've noticed that I have both PostgreSQL 8.3 & 8.4 installed, is this really necessary?
    Can I safely delete the 8.3 version in some way without risking lossing any important data?

    Any help with this is highly appreciated, thanks.

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Only one postgresql installation can be active per port.
    You should check in the windows services which one is active.
    Start pgadmin and try to connect to both servers. If only one of them works you can delete the other one.

  3. #3
    Junior Member
    Join Date
    Jun 2009
    Posts
    9

    Default

    When looking at the windows services the 8.4 version is the only one started.
    Both has "Automatic" as startup method.
    Visible differences is that the 8.3 is labeled as "Database Server" while 8.4 is only labbeld as "Server".
    Another difference is that the 8.3 has "postgresuser" as user when 8.4 has "postgres" as user.

    I can connect to both servers with pgadmin and by the looks of it they have the same content.
    For example the HM2 database I created a couple of days ago is visible in both of them.

    When looking in the postgresql program files folder I can see that the 8.3 database was created 2009-06-06 and have a size of 780 MB while the 8.4 database was created 2011-01-30 and have a size of 2,45 GB.

    I'm pretty sure I have only installed one database myself during the years I've used HM so I have no idea why I have two of them?
    Last edited by Nic; 08-11-2011 at 04:36 AM.

  4. #4
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    I guess its just the 8.4 service that is active and pgadmin uses the same connection data for both entries so you are always connected to 8.4.

    Please rename the 8.3 data folder and run some tests including a PC reboot. If everything is still working as expected it is safe to uninstall postgresql 8.3.

  5. #5
    Junior Member
    Join Date
    Jun 2009
    Posts
    9

    Default

    I went ahead with the testing and then uninstalled and everything seems to work fine.

    Thanks a lot for the help!

Similar Threads

  1. HEM continually sets unwanted import folder
    By darklingroom in forum Manager General
    Replies: 1
    Last Post: 08-02-2011, 09:22 PM
  2. Double or nothing?
    By robis in forum Manager General
    Replies: 1
    Last Post: 08-24-2010, 07:13 PM
  3. Graphing sets hit
    By darkstar in forum Manager General
    Replies: 1
    Last Post: 02-16-2010, 08:48 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •