Re: Upgrade from 9.1 to 9.10 - Mailing list pgsql-general

From David Johnston
Subject Re: Upgrade from 9.1 to 9.10
Date
Msg-id 1382379154815-5775296.post@n5.nabble.com
Whole thread Raw
In response to Upgrade from 9.1 to 9.10  (ramistuni <ramistuni@yahoo.com>)
Responses Re: Upgrade from 9.1 to 9.10  (ramistuni <ramistuni@yahoo.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Upgrade from 9.1 to 9.10
Next
From: Tom Lane
Date:
Subject: Re: locks held during commit with synchronous replication