Postgres Pro
Downloads
Home   >   mailing lists

Re: How to upgrade from 9.1 to 9.2 with replication? - Mailing list pgsql-performance

From Claudio Freire
Subject Re: How to upgrade from 9.1 to 9.2 with replication?
Date
Msg-id CAGTBQpZX3wjbHHk8nrpXZhtuZT2k8G7Ct19y6Bw27yLFiufsSQ@mail.gmail.com
Whole thread Raw
In response to Re: How to upgrade from 9.1 to 9.2 with replication?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: How to upgrade from 9.1 to 9.2 with replication?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-performance
Tree view 
On Wed, Nov 7, 2012 at 3:36 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> Bring both down.
>> pg_upgrade master
>> Bring master up
>> pg_upgrade slave
>
> Is there any reason to upgrade the slave when you are going to do rsync
> anyway?  Of course you need to install the new binaries and libs, but it
> seems running pg_upgrade on the standby is unnecessary.

Just to speed up the rsync

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
Next
From: Rodrigo Rosenfeld Rosas
Date:
Subject: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2