On Wed, Apr 29, 2015 at 01:13:13PM +0200, Magnus Hagander wrote: > On Wed, Apr 29, 2015 at 6:19 AM, Aaron Burnett <Aaron.Burnett@xxxxxxxxxxxxxxxx> > wrote: > > > > 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? > > > > > You upgrade the master, and then you rebuild the standbys from a new basebackup > (using pg_basebackup or manually with start/stop backups etc). You can't > upgrade the standbys and have them re-join the master, they have to be redone > from scratch. Well, 9.5's pg_upgrade manual page has instructions on upgrading streaming standbys via rsync, and it will work for all versions of pg_upgrade back to 9.0: http://www.postgresql.org/docs/devel/static/pgupgrade.html Let me know if you have any problems. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
