On Mon, 2009-01-26 at 14:58 -0500, Jeff wrote: > voila. I have 2 full copies of the db. You could even expand it a bit > and after the rsync & friends have it fire up the instance and run > pg_dump against it for a pg_restore compatible dump "just in case". > > It takes a long time to restore a 300GB db, even if you cheat and > parallelify some of it. 8.4 may get a pg_restore that can load in > parallel - which will help somewhat.
Somewhat? Just to be clear, if you have the hardware for it, parallel restore can take a 500GB restore in 2.5 hours (versus 15). IMO, that is a *little* more than somewhat. Maybe, a bit? ;) Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
