Search Postgresql Archives

Re: Upgrade from 9.1 to 9.10

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux