pgsql: pg_dump: Lock all relations, not just plain tables

Поиск
Список
Период
Сортировка
Искать

pgsql: pg_dump: Lock all relations, not just plain tables

От:
Alvaro Herrera <alvherre@alvh.no-ip.org>
Дата:
pg_dump: Lock all relations, not just plain tables

Now that LOCK TABLE can take any relation type, acquire lock on all
relations that are to be dumped.  This prevents schema changes or
deadlock errors that could cause a dump to fail after expending much
effort.  The server is tested to have the capability and the feature
disabled if it doesn't, so that a patched pg_dump doesn't fail when
connecting to an unpatched server.

Backpatch to 9.5.

Author: Álvaro Herrera 
Reviewed-by: Tom Lane 
Reported-by: Wells Oliver 
Discussion: https://postgr.es/m/20201021200659.GA32358@alvherre.pgsql

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/64fc3e03495162154797f7d01e871462b1f42979

Modified Files
--------------
src/bin/pg_dump/pg_backup.h    |  2 ++
src/bin/pg_dump/pg_backup_db.c | 64 ++++++++++++++++++++++++++++++++++++++++++
src/bin/pg_dump/pg_backup_db.h |  2 ++
src/bin/pg_dump/pg_dump.c      | 17 ++++++-----
4 files changed, 78 insertions(+), 7 deletions(-)

FAQ