The DB size is around 11-12 GB. Yes I am planning to take a downtime for upto 1 hour if required. I would like to understand the rollback steps if things go murky.
Thanks,
Rajiv
From: Vasilis Ventirozos [mailto:v.ventirozos@gmail.com]
Sent: Thursday, April 18, 2013 4:49 PM
To: rajiv.kasera@pinelabs.com
Subject: Re: [ADMIN] Upgrade from 8.4
On Thu, Apr 18, 2013 at 2:10 PM, Rajiv Kasera <rajiv.kasera@pinelabs.com> 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 me with a guide for the upgrade process and rollback process in case anything fails.
Thanks,
Rajiv
you haven't told us anything about your database size or if any downtime is acceptable, generally a pg_dump and reload should work without any problem but it requires downtime,if you need more specifics you should give us more details.