From: Bruce Momjian <bruce@momjian.us>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: Karl Denninger <karl@denninger.net>
Cc: delongboy <sdelong@saucontech.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
Date: Wed, 7 Nov 2012 15:59:18 -0500
Message-ID: <20121107205918.GD26215@momjian.us> (raw)
In-Reply-To: <CAGTBQpZX3wjbHHk8nrpXZhtuZT2k8G7Ct19y6Bw27yLFiufsSQ@mail.gmail.com>
References: <1350598882643-5728941.post@n5.nabble.com>
<50816749.6010804@denninger.net>
<CAGTBQpa_ZFEyzFGE_8+diVjUOiYMFARkUrPs2reBq71GaJ-tvg@mail.gmail.com>
<20121107183633.GA19163@momjian.us>
<CAGTBQpZX3wjbHHk8nrpXZhtuZT2k8G7Ct19y6Bw27yLFiufsSQ@mail.gmail.com>
On Wed, Nov 7, 2012 at 03:44:13PM -0300, Claudio Freire wrote:
> 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
pg_upgrade is mostly modifying the system tables --- not sure if that is
faster than just having rsync copy those. The file modification times
would be different after pg_upgrade, so rsync might copy the file anyway
when you run pg_upgrade. It would be good for you to test if it really
is a win --- I would be surprised if pg_upgrade was in this case on the
standby.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruce@momjian.us, klaussfreire@gmail.com, karl@denninger.net, sdelong@saucontech.com
Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
In-Reply-To: <20121107205918.GD26215@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox