On Wed, Jul 10, 2013 at 2:14 PM, Wells Oliver <[email protected]> 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/[email protected] -- 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: [email protected] -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
