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
  • 83,961
  • 28
  • 402
  • 634
guettli
  • 1,521
  • 5
  • 24
  • 49
  • Just for the records. I solved my use case with this answer: https://dba.stackexchange.com/a/186051/5705 – guettli Sep 27 '17 at 08:10

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