Re: Backup?

On Thu, 2003-09-04 at 15:40, Doug McNaught wrote:
> 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.

And it's smaller than the data/ directory, especially when "-F c"
option is used.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"The UN couldn't break up a cookie fight in a Brownie meeting."
Larry Miller