From: Bruce Momjian <bruce@momjian.us>
To: Sergey Konoplev <gray.ru@gmail.com>
Cc: Wells Oliver <wellsoliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrading from 9.1 to 9.2 - master AND slave
Date: Tue, 16 Jul 2013 05:58:55 -0400
Message-ID: <20130716095855.GA28068@momjian.us> (raw)
In-Reply-To: <CAL_0b1sW1dT5j1M5zt1KHK_31hQyO45hK1HVfLumQR5nC=9KjQ@mail.gmail.com>
References: <CAOC+FBXubinkZYwcJ3Rx4XGrJcGUPLX=CGXSkf4t+39DJZ1fCA@mail.gmail.com>
<CAL_0b1sW1dT5j1M5zt1KHK_31hQyO45hK1HVfLumQR5nC=9KjQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Sun, Jul 14, 2013 at 09:31:16PM -0700, Sergey Konoplev wrote:
> On Wed, Jul 10, 2013 at 2:14 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
> > 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?
>
> The problem is that after pg_upgrade the system catalog on the servers
> wont match. Therefore you need to rebuild your slave from scratch.
>
> There were some ideas around rsync [1], however, nobody proved that
> they work appropriately.
>
> [1] http://www.postgresql.org/message-id/20120320204916.GB26163@momjian.us
Yes, though there was discussion about this at PGCon 2013 and I plan to
work on this for 9.4.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: bruce@momjian.us, gray.ru@gmail.com, wellsoliver@gmail.com
Subject: Re: Upgrading from 9.1 to 9.2 - master AND slave
In-Reply-To: <20130716095855.GA28068@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