Thread: 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
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 > >
Le Jeudi 27 Juin 2002 10:57, Michael Del Solio a écrit : > Hi, > > i have a question about pg_dump. > > Does pg_dump dump a consistent snapshot of a database? yes > When pg_dump starts with the first table while other tables are modified > does pg_dump take modifications of modified tables? no > 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. yes > Thanks > Michael > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster