pg_dump consistency. - Mailing list pgsql-general

From Marc Wrubleski
Subject pg_dump consistency.
Date
Msg-id 3AD22783.F0F4E597@sorexsoftware.com
Whole thread Raw
Responses Re: pg_dump consistency.
Re: pg_dump consistency.
List pgsql-general
Hi all,

I have been reading but cannot find this particular bit of info.

I need to guarantee to my customer that the pg_dump is consistent. I
couldn't guarantee consistency if the pg_dump is run while the db is
on-line, and we cannot take the db off-line to do backups.

So, can anyone tell me
1. IF pg_dump is consistent (without taking the db offline),
2. if so, how does it do it?
3. if not, how can we get consistent backups without taking the db
offline?

Thanks.

Marc Wrubleski


pgsql-general by date:

Previous
From: "Dominic J. Eidson"
Date:
Subject: Re: Re: Virtual domains ?
Next
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL admin or monitor program?