Upgrading from 9.1 to 9.2 - master AND slave

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrading from 9.1 to 9.2 - master AND slave
Date: 2013-07-10 21:14:47
Message-ID: CAOC+FBXubinkZYwcJ3Rx4XGrJcGUPLX=CGXSkf4t+39DJZ1fCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thanks.

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Struckhoff, Kevin 2013-07-10 21:58:38 Connecting to a remote db server
Previous Message Vincent Lau 2013-07-10 21:11:01 Re: Upgrading from 9.1 to 9.2 in place, same machine