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 <[email protected]>wrote: > On Wed, Jul 10, 2013 at 1:53 PM, Wells Oliver <[email protected]> > 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 > > [email protected] > > > -- > Sent via pgsql-admin mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Wells Oliver [email protected]
