Re: Backup?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup?
Date: 2003-09-04 20:40:39
Message-ID: m34qzsthh4.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bjørn T Johansen <btj(at)havleik(dot)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

In response to

  • Backup? at 2003-09-04 19:31:52 from Bjørn T Johansen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2003-09-04 20:44:37 Re: searching archives should be a weeeee bit faster ...
Previous Message DeJuan Jackson 2003-09-04 20:34:03 Re: is it possible to do this? have a subselect that