April 22nd, 2013, 12:25 AM
Postgresql 8.4.2 upgrade RHEL 5.5
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?
June 11th, 2013, 07:02 PM
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
June 19th, 2013, 08:58 AM
This seems a good idea. Thanks for the help.
Originally Posted by lukusc