pg_dump / consistent snapshot / backup - Mailing list pgsql-general

From Michael Del Solio
Subject pg_dump / consistent snapshot / backup
Date
Msg-id 20020627105744.00001acd.michael.delsolio@creditplus.de
Whole thread Raw
Responses Re: pg_dump / consistent snapshot / backup
List pgsql-general
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




pgsql-general by date:

Previous
From: "Alison Stevenson"
Date:
Subject: user defined functions
Next
From: 黄春茂
Date:
Subject: How to get the used time when operate a select query?