From: ktm@rice.edu <ktm@rice.edu>
To: Jonathan Nalley <jnalley@jnalley.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Date: Wed, 10 Jul 2013 13:16:00 -0500
Message-ID: <20130710181600.GG3001@aart.rice.edu> (raw)
In-Reply-To: <CAEiqQGbcHAqYvoGh2XnMD+n2UG57Dk7b0861te5go+ye7mHgPA@mail.gmail.com>
References: <CAOC+FBUZL60+OzFXoQZFRL42Zn2DDkyhmmOUx3SKE4Xv1y=eYQ@mail.gmail.com>
<CAEiqQGbcHAqYvoGh2XnMD+n2UG57Dk7b0861te5go+ye7mHgPA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Wed, Jul 10, 2013 at 02:08:04PM -0400, Jonathan Nalley wrote:
> On Wed, Jul 10, 2013 at 1:53 PM, Wells Oliver <wellsoliver@gmail.com> wrote:
> > I have 9.1 running on 5432, and 9.2 running on 5433. The 9.1 database size
> > is 153g. 9.1 is actively used by systems, 9.2 is just sitting there empty.
> >
> > I'd like to move the 9.1 database to 9.2 without any down time, and ensuring
> > that no data is lost.
> >
> > My original idea was to make 9.2 a slave of 9.1, then switch it over.
> >
> > Is there a better idea? Thanks for any tips.
>
> have you looked at simply using pg_upgrade ?
>
> http://www.postgresql.org/docs/9.2/static/pgupgrade.html
>
Hi Wells,
I would definitely consider pgupgrade. You could test it first to get
some timings. I would make a 9.1 slave on the same box and run pg_upgrade
against it. Then if you have a problem you can restart using the original.
You can also use something like slony or bucardo to replicate from 9.1 to
9.2 and then failover to it that way.
Regards,
Ken
--
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: ktm@rice.edu, jnalley@jnalley.com
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
In-Reply-To: <20130710181600.GG3001@aart.rice.edu>
* 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