Re: pg_dump and data consistency in the backup

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: ing(dot)Martin Prá?ek <prasek(at)silesia(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and data consistency in the backup
Date: 2003-05-25 13:48:33
Message-ID: 20030525134833.GA1057@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 21, 2003 at 19:12:31 +0200,
"ing.Martin Prá?ek" <prasek(at)silesia(dot)cz> wrote:
> How pg_dump honor data consistency on its output?

The dump is done in a transaction. Only transactions committed at the
start of the dump will be included in the dump. The database is not
locked while this is going on, so that it is still available for use
while the dump is being done.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-05-25 16:21:53 Re: User and Timestamps
Previous Message listrec 2003-05-25 10:55:24 Re: Slashdot: SAP and MySQL Join Forces