Postgres Pro
Downloads
Home   >   mailing lists

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

From Wells Oliver
Subject Re: Upgrading from 9.1 to 9.2 in place, same machine
Date
Msg-id CAOC+FBXwnwoE076-o2Xnph9qOi_monAeK9f3-RQjUx4TyOsLWQ@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading from 9.1 to 9.2 in place, same machine  (Jonathan Nalley <jnalley@jnalley.com>)
Responses Re: Upgrading from 9.1 to 9.2 in place, same machine  (Vincent Lau <vincent.lau@rentrakmail.com>)
Re: Upgrading from 9.1 to 9.2 in place, same machine  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-admin
Tree view
Can anyone speak to the speed of pg_upgrade? Our database is 153GB. From 9.1 to 9.2, I'm nervous it might take hours. If it were less than hour, downtime would be more acceptable.


On Wed, Jul 10, 2013 at 11:08 AM, Jonathan Nalley <jnalley@jnalley.com> 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


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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Wells Oliver
wellsoliver@gmail.com

pgsql-admin by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine
Next
From: Vincent Lau
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine