1

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?

Paul White
  • 94,921
  • 30
  • 437
  • 687
guettli
  • 1,591
  • 5
  • 25
  • 51

1 Answers1

3

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.

Dynamite
  • 159
  • 4