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, From: Vasilis Ventirozos [mailto:v.ventirozos@xxxxxxxxx] On Thu, Apr 18, 2013 at 2:10 PM, Rajiv Kasera <rajiv.kasera@xxxxxxxxxxxx> 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, Hey, 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. Regards, Vasilis Ventirozos |
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
