hi Marc
If u log all the queries which get executed when a dump takes place u
will find that the pg_dump process first sets the transaction isolation
level to serializable..
So i guess all the state of the database dumped is consistent with a
point in time..
Hope this helps
Anand
On Mon, Apr 09, 2001 at 03:20:03PM -0600, Marc Wrubleski wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)