-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/17/07 16:49, Michael Nolan wrote: > I don't know if my database is typical (as there probably is no such > thing), but to restore a full dump (pg_dumpall) takes over 4 hours on my > backup server, but to restore a low level backup (about 35GB)
Meaning a tarball of $PGDATA? > and then > process 145 WAL files (since Tuesday morning when the last low level > backup was run) took me around 2 hours today - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGTN0BS9HxQb37XmcRArY4AKCzTzoe2XP1COyjpdWD+wGp5ACYoACfd9fx 336CjyTBXkgu/lXZewagcOA= =+/58 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings