Re: How to upgrade from 9.1 to 9.2 with replication?

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Karl Denninger <karl(at)denninger(dot)net>, delongboy <sdelong(at)saucontech(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
Date: 2012-11-07 18:44:13
Message-ID: CAGTBQpZX3wjbHHk8nrpXZhtuZT2k8G7Ct19y6Bw27yLFiufsSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 7, 2012 at 3:36 PM, Bruce Momjian <bruce(at)momjian(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rodrigo Rosenfeld Rosas 2012-11-07 20:29:11 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Previous Message Bruce Momjian 2012-11-07 18:36:33 Re: How to upgrade from 9.1 to 9.2 with replication?