9.4 upgrade Help using pg_upgrade
Current Architecture
Primary Hot Standby
Postgresql 9.3 Postgresql 9.3
DB Size 1.4 TB Database Size 1.4 TB
Want to upgrade both primary and hot Standby to 9.4 at same time. I m not able to figure out how to upgrade Hot standby and primary simultaneously. What ever I have read so far only tells me about upgrading primary which I am able to do it . Can anyone please guide me How to upgrade Secondary database so that I don’t have to build standby again from the scratch after upgrading primary database?
Thanks
Prabhjot
On Thu, Dec 3, 2015 at 12:33:25AM +0000, Sheena, Prabhjot wrote:
Current Architecture
Primary Hot Standby
Postgresql 9.3 Postgresql 9.3
DB Size 1.4 TB Database Size 1.4 TBWant to upgrade both primary and hot Standby to 9.4 at same time. I m not able
to figure out how to upgrade Hot standby and primary simultaneously. What ever
I have read so far only tells me about upgrading primary which I am able to do
it . Can anyone please guide me How to upgrade Secondary database so that I
don’t have to build standby again from the scratch after upgrading primary
database?
Yes, read the 9.5 docs for upgrading the standby --- it also works for
9.4 and earlier:
http://momjian.us/main/blogs/pgblog/2015.html#June_10_2015
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general