Bjørn T Johansen <btj@havleik.no> 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