On 27.04.2007 03:09, CAJ CAJ wrote:
Forgive me if this has been discussed before (or if it sounds absurd)
Upgrading large postgres databases (100GB+) takes awfully long time when
doing dump/restore. I was wondering if this process can be optimized by
directly dumping to a new version of Pg database directly on another server
without having to dump to the filesystem and then restore it.
pg_dump on new server might look something like,
pg_dump <options> -h <old server> -h <new_server> dbname
or can it be used as-is by piping it?
pg_dump <options> -h <old server> dbname | pg_restore
Maybe consider using slony to get your data over as well..
--
Regards,
Hannes Dorbath
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
