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.delsolio@creditplus.de>
To: <pgsql-general@postgresql.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
>
>