Bj�rn T Johansen <[EMAIL PROTECTED]> writes:
> Should one use pg_dumpall to backup the database or is it more practical
> to just copy the data directory?
The data directory will not be consistent unless the server is
stopped. pg_dumpall works well, produces a consistent backup and is
easily portable to a different machine architecture if need be.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org