pg_dump / consistent snapshot / backup

From: Michael Del Solio <michael(dot)delsolio(at)creditplus(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump / consistent snapshot / backup
Date: 2002-06-27 08:57:44
Message-ID: 20020627105744.00001acd.michael.delsolio@creditplus.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 黄春茂 2002-06-27 09:10:13 How to get the used time when operate a select query?
Previous Message Alison Stevenson 2002-06-27 08:44:08 user defined functions