Re: [ADMIN] Upgrade from 8.4

2013-04-19 Thread Rajiv Kasera
...@pinelabs.com Subject: Re: [ADMIN] Upgrade from 8.4 On Thu, Apr 18, 2013 at 2:10 PM, Rajiv Kasera wrote: I am planning to upgrade my Postgres DB server from v8.4 to a newer version. Should 9.2 be a good choice for upgrading, it has the best features around replication. Also can someone help

Re: [ADMIN] Upgrade from 8.4

2013-04-18 Thread Brett Stauner
I recently upgraded from the 8.2 branch to 9.2. Since mine was so old the only option I had was the dump/restore functionality, but that's really a simple procedure, just potentially time consuming based on your data and computers. It's also good to look over the release notes between the version

Re: [ADMIN] Upgrade from 8.4

2013-04-18 Thread Prashanth Ranjalkar
Yes, PostgreSQL 9.2 would be an excellent choice; There are various upgrade options available like dump/restore, slony and pg_upgrade where each have their pros and cons. The selection of upgrade method solely depend upon the data size and available downtime. It's strongly recommended to test upgra

[ADMIN] Upgrade from 8.4

2013-04-18 Thread Rajiv Kasera
I am planning to upgrade my Postgres DB server from v8.4 to a newer version. Should 9.2 be a good choice for upgrading, it has the best features around replication. Also can someone help me with a guide for the upgrade process and rollback process in case anything fails. Thanks, Rajiv smime.