Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading from 9.1 to 9.2 in place, same machine - Mailing list pgsql-admin

From Jonathan Nalley
Subject Re: Upgrading from 9.1 to 9.2 in place, same machine
Date
Msg-id CAEiqQGbcHAqYvoGh2XnMD+n2UG57Dk7b0861te5go+ye7mHgPA@mail.gmail.com
Whole thread Raw
In response to Upgrading from 9.1 to 9.2 in place, same machine  (Wells Oliver <wellsoliver@gmail.com>)
Responses Re: Upgrading from 9.1 to 9.2 in place, same machine  ("ktm@rice.edu" <ktm@rice.edu>)
Re: Upgrading from 9.1 to 9.2 in place, same machine  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-admin
Tree view 
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


>
> --
> Wells Oliver
> wellsoliver@gmail.com

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Upgrading from 9.1 to 9.2 in place, same machine
Next
From: Chris Ernst
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine