I want to do a final pg_dumpall on a server, then copy the output to a different server and restore the db there.

How can I avoid modification to the database during pg_dumpall?


1 Answer 1


From the pg_dump documentation :

It makes consistent backups even if the database is being used concurrently.

So the backup process takes a snapshot of the DB on a specific moment so each commits which are made during the process are ignored.


Not the answer you're looking for? Browse other questions tagged or ask your own question.