Hard linking means that you must maintain 8.2's data directory though, even after upgrade, correct? Since it's a link and not a copied file.
On Wed, Jul 10, 2013 at 11:59 AM, Vincent Lau <[email protected]>wrote: > We did an in-place upgrade(with the -k option) against a 6Tb DB from 8.4 > to 9.2. It took all of 10 minutes to complete, which didn't count for > running the analyze afterward. However, if you are going to run the analyze > DB afterward, your mileage may vary. > > > On Wed, Jul 10, 2013 at 11:52 AM, Wells Oliver <[email protected]>wrote: > >> 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] >> > > > > -- > Vincent Lau | Database Administrator > 503.284.7581 x394 | [email protected] <[email protected]> > RENTRAK | www.rentrak.com | NASDAQ: RENT > > Notice: This message is confidential and is intended only for the > recipient(s) named above. If you have received this message in error, > or are not the named recipient(s), please immediately notify the > sender and delete this message. > -- Wells Oliver [email protected]
