On Thu, 2003-09-04 at 15:40, Doug McNaught wrote: > 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.
And it's smaller than the data/ directory, especially when "-F c" option is used. -- ----------------------------------------------------------------- Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA "The UN couldn't break up a cookie fight in a Brownie meeting." Larry Miller ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
