Re: 9.4 upgrade Help using pg_upgrade

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                             +