Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and data consistency in the backup - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: pg_dump and data consistency in the backup
Date
Msg-id 20030525134833.GA1057@wolff.to
Whole thread Raw
In response to pg_dump and data consistency in the backup  ("ing.Martin Prášek" <prasek@silesia.cz>)
List pgsql-general
Tree view 
On Wed, May 21, 2003 at 19:12:31 +0200,
  "ing.Martin Prá?ek" <prasek@silesia.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.

pgsql-general by date:

Previous
From: "listrec"
Date:
Subject: Re: Slashdot: SAP and MySQL Join Forces
Next
From: Holger Klawitter
Date:
Subject: Re: latin1 -> unicode