Re: Backup? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Backup?
Date
Msg-id m34qzsthh4.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Backup?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Backup?
List pgsql-general
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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Backup?
Next
From: DeJuan Jackson
Date:
Subject: Re: is it possible to do this? have a subselect that