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?
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?
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.