On Sun, Jul 14, 2013 at 09:31:16PM -0700, Sergey Konoplev wrote: > On Wed, Jul 10, 2013 at 2:14 PM, Wells Oliver <wellsoliver@xxxxxxxxx> wrote: > > Following up to my earlier post: I have a master and a slave server (using > > WAL), both 9.1. My 9.2 upgrade process is: > > > > 1) stop postgres on both servers > > 2) run pg_upgrade --link on both servers > > 3) change ports so 9.2 is on 5432, 9.1 on 5433 > > 4) restart > > > > Is this the best way to do it and ensure that the WAL is still being created > > and the master/slave relationship properly maintained? > > The problem is that after pg_upgrade the system catalog on the servers > wont match. Therefore you need to rebuild your slave from scratch. > > There were some ideas around rsync [1], however, nobody proved that > they work appropriately. > > [1] http://www.postgresql.org/message-id/20120320204916.GB26163@xxxxxxxxxx Yes, though there was discussion about this at PGCon 2013 and I plan to work on this for 9.4. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
