Upgrading hot standbys - Mailing list pgsql-general

From Aaron Burnett
Subject Upgrading hot standbys
Date
Msg-id 1430281269122.10405@us.dunnhumby.com
Whole thread Raw
Responses Re: Upgrading hot standbys  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general


Greetings,


I'm in the process of upgrading PG 9.1.3 to 9.4.1 in the near future.


I have several machines which each house unique databases. Each of those are replicated to a standby server with matching configurations. A total of 10 servers, 5 masters, 5 slaves. Everything runs on Ubuntu.


My question, as I can't seem to find any documentation on this part, is once I successfully upgrade the master I will need to upgrade the standby as well. Will I have to rebuild the standby from scratch, or will the standby pick up where it was before the upgrade if I do things correctly?


Thanking you in advance,



Aaron

dunnhumby limited is a limited company registered in England and Wales with registered number 02388853 and VAT registered number 927 5871 83. Our registered office is at Aurora House, 71-75 Uxbridge Road, London W5 5SL. The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error you should delete it from your system immediately and advise the sender. dunnhumby may monitor and record all emails. The views expressed in this email are those of the sender and not those of dunnhumby.

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: newsfeed type query
Next
From: Mitu Verma
Date:
Subject: clearing of the transactions shown in pg_locks