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