| From: | Aaron Burnett <Aaron(dot)Burnett(at)us(dot)dunnhumby(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org' (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Upgrading hot standbys |
| Date: | 2015-04-29 04:19:51 |
| Message-ID: | 1430281269122.10405@us.dunnhumby.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitu Verma | 2015-04-29 05:32:28 | clearing of the transactions shown in pg_locks |
| Previous Message | Jim Nasby | 2015-04-29 01:26:29 | Re: newsfeed type query |