> What's the advantage of using pg_dumpall over tar/gzip for backup?
pg_dumpall grabs a constent snapshot of the data. tar/gzip is just
backing up the files, so you can get some data in some table that is
committed, but miss data in another table that is part of the same
transaction. Of course, if the database is not being used, this is not
an issue.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
