Upgrading PostGresql
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Aug 2009
    Posts
    24

    Default Upgrading PostGresql

    I have the original version 8.4 which doesn't seem to have any problems however I run Secunia psi which says it's a minor hacking risk which concerns me a little. Is it necessary? And I notice there's a version 9 now, should I go for that one?
    Last edited by Barge Ass; 02-21-2011 at 12:51 AM.

  2. #2
    Junior Member
    Join Date
    May 2009
    Posts
    16

    Default Updating PostgreSQL

    I also have a question about this same topic. I currently am running 8.3 for my HEM database and PT3 database... however I think I need to update to the most recent version of 8.3 because PT3 sucks... will this affect my HEM databases at all? Also, how do you update it and how do you tell which variant of 8.3 I have?

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

    Default

    In general: never touch a running postgresql installation.

    If you want to upgrade: make database backups before starting the installation.

    Minor upgrades (for example from 8.3.x to 8.3.x+n): this should run without problems and without loss of data

    Major upgrades (for example from 8.3.x to 8.4.x): there is no update procedure for this: you need to install the newer version separately on a different port or uninstall the old version before installing the new version. You will need to restore your databases from a backup.

Similar Threads

  1. "upgrading" postgreSQL 8.3 to 8.4 -> missing old DB
    By simon in forum Manager General
    Replies: 2
    Last Post: 09-03-2010, 08:52 AM
  2. Upgrading to HEM with PLO
    By Kcannon in forum Manager General
    Replies: 1
    Last Post: 06-02-2010, 09:17 PM
  3. Upgrading PostgreSQL 8.3 to 8.4
    By idareyou in forum Manager General
    Replies: 5
    Last Post: 09-28-2009, 09:35 AM
  4. upgrading from 1.05 to 1.06
    By Mirrorkisser in forum Manager General
    Replies: 1
    Last Post: 09-30-2008, 01:06 PM
  5. upgrading PostgreSQL from 8.2 to 8.3
    By originaL in forum Manager General
    Replies: 1
    Last Post: 07-30-2008, 04:23 PM

Posting Permissions

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