#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Postgresql 8.4.2 upgrade RHEL 5.5


    Hello,

    I have an old RHEL Server that has simple Postgresql database. I have never had to upgrade it before. Now I was planning to upgrade it to the latest release, but I was unable google guides to do so.

    I reregistered the server to RHN and Red Hat gives with their repos version 8.4.13 with yum list updates.

    Question: Can I just install the Postgresql repo and do yum update postgresql? Or are there another steps I need to take?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2010
    Posts
    4
    Rep Power
    0
    Hi kovax,

    In the past I have upgraded by doing the following...

    If you require near 100% uptime...
    1) Download the new postgres (9.2 would seem to be the best choice.
    2) Install that on the same server but use a different port
    3) Install SlonyI
    4) Set up the replication from the 8.4 db to the 9.2 db
    5) run the slonyI failover to make the 9.2 db the master (only once replication has finished)
    6) reset the port for for the new 9.2 DB
    7) shut down you 8.4 db
    8) restart your 9.2 db to make sure its listening on the correct port

    If downtime isn't a problem...
    1) backup your db
    2) Shut down your 8.2 db
    3) install postgres 9.2
    4) restore to 9.2

    Cheers
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0
    Hello,

    This seems a good idea. Thanks for the help.

    Originally Posted by lukusc
    Hi kovax,

    In the past I have upgraded by doing the following...

    If you require near 100% uptime...
    1) Download the new postgres (9.2 would seem to be the best choice.
    2) Install that on the same server but use a different port
    3) Install SlonyI
    4) Set up the replication from the 8.4 db to the 9.2 db
    5) run the slonyI failover to make the 9.2 db the master (only once replication has finished)
    6) reset the port for for the new 9.2 DB
    7) shut down you 8.4 db
    8) restart your 9.2 db to make sure its listening on the correct port

    If downtime isn't a problem...
    1) backup your db
    2) Shut down your 8.2 db
    3) install postgres 9.2
    4) restore to 9.2

    Cheers

IMN logo majestic logo threadwatch logo seochat tools logo