Re: database changes during a pg_dump

"Birchall, Austen" <austen.birchall@metoffice.gov.uk> writes:
> If I do a
> pg_dump -Fc dbname -U postgres > backup.out

> to backup a database am I right to assume that any changes made to the database such as a row update that are made
whilethe pg_dump is actually  running will be captured in the resulting backup.out file? 

No.  You'll get a snapshot as of pg_dump's starting time.

There are some corner cases about DDL that's in progress while pg_dump
starts up, but user data will definitely adhere to the snapshot.

            regards, tom lane