9

As subjects, what will happen to the backup file while there is still many active transaction in the database. Does it export realtime or just partially backups ?

thanks in advance.

Brain90
  • 1,551
  • 18
  • 21

2 Answers2

10

pg_dump runs in a serializable transaction, so it sees a consistent snapshot of the database including system catalogs.

However it is possible to get 'cache lookup failed' error if someone performs DDL changes while a dump is starting. The time window for this sort of thing isn't very large, but it can happen. See: http://archives.postgresql.org/pgsql-bugs/2010-02/msg00187.php

mnencia
  • 3,298
  • 1
  • 23
  • 35
2

pg_dump will give you a consistent state. Any transaction not completed before pg_dump has been issued will not be reflected.

knitti
  • 6,817
  • 31
  • 42