Home > mailing lists

Upgrading from 9.1 to 9.2 - master AND slave - Mailing list pgsql-admin

From	Wells Oliver
Subject	Upgrading from 9.1 to 9.2 - master AND slave
Date	July 10, 2013 21:14:55
Msg-id	CAOC+FBXubinkZYwcJ3Rx4XGrJcGUPLX=CGXSkf4t+39DJZ1fCA@mail.gmail.com Whole thread Raw
Responses	Re: Upgrading from 9.1 to 9.2 - master AND slave
List	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.

From: Vincent Lau
Date: 10 July 2013, 21:11:28
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine

From: "Struckhoff, Kevin"
Date: 10 July 2013, 22:15:30
Subject: Connecting to a remote db server