--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > 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.
>
But there are other issues, I think.
Because pg_dump(all) does not backup the database
itself but rather the commands needed to reconstruct
it, it is more portable (between
versions/architectures) and, above all,
more efficient. For one thing, it does not backup
up the indexes, only the definitions, so that
they can be rebuilt. That saves much space.
Hernan Gonzalez
Argentina
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
