Thursday, 8 August 2013

Running pg_dump while insert queries are still running?

Running pg_dump while insert queries are still running?

If I run pg_dump to dump a table into a SQL file, does it take a snapshot
of the last row in the table, and dump all the rows up to this row?
Or does it keep dumping all the rows, even those that were inserted after
pg_dump was ran?
A secondary question is: Is it a good idea to stop all insert queries
before running pg_dump?

No comments:

Post a Comment