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 -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@xxxxxxxxx -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
