Re: Upgrade from 9.1 to 9.10

ramistuni wrote
> We are currently running "PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu,
> compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit"

This is packaging (thus Linux Distro) concern and not that of PostgreSQL
proper. As I use Ubuntu and you appear to be using a Red Hat variant I
cannot help with specifics but assuming you (or someone) installed
PostgreSQL from a (Yum?) package that same mechanism would be used to
perform the upgrade.

0) Ensure you have working backups
1) Shut down PostgreSQL on all three servers
2) Run the relevant package upgrade command on each of the servers
3) Start PostgreSQL on all three servers.

Not positive about the order but I would think:
Shutdown Primary, Standby, Archive
Startup Archive, Standby, Primary

Suggest you practice in a development/staging/testing virtual environment
(snapshot-update-revert) before performing on production machines.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Upgrade-from-9-1-to-9-10-tp5775290p5775296.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.