Re: pg_dump / consistent snapshot / backup

From the documentation:

"Dumps created by pg_dump are internally consistent, that is, updates to the
database while pg_dump is running will not be in the dump."

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/backup.html

Greg

----- Original Message -----
From: "Michael Del Solio" <michael(dot)delsolio(at)creditplus(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, June 27, 2002 4:57 AM
Subject: [GENERAL] pg_dump / consistent snapshot / backup

> Hi,
>
> i have a question about pg_dump.
>
> Does pg_dump dump a consistent snapshot of a database?
>
> When pg_dump starts with the first table while other tables are modified
> does pg_dump take modifications of modified tables?
>
> Or take pg_dump the modified tables with their initial values of start of
pg_dump?
> I think it must be so. Otherwise pg_dump would not be suitable for
backups.
>
> Thanks
> Michael
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>