medium10 pts · first answer countsbackup-recoverypostgresql

Is pg_dump consistent?

pg_dump takes 2 hours on a live database while users keep writing. What does the dump contain?

A.A consistent snapshot of the database as of the moment the dump startedB.A mix of old and new rows, so foreign keys may breakC.Only the rows that did not change during the dumpD.Nothing, because pg_dump blocks all writes until it finishes

← Reports cancelled on the replica Restoring a Percona XtraBackup →