Обсуждение: 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 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? 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 +