pgsql: Fix pg_restore's misdesigned code for detecting archive file for

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix pg_restore's misdesigned code for detecting archive file for
Дата
Msg-id E1lS1DK-00038n-CJ@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix pg_restore's misdesigned code for detecting archive file format.

Despite the clear comments pointing out that the duplicative code
segments in ReadHead() and _discoverArchiveFormat() needed to be
in sync, they were not: the latter did not bother to apply any of
the sanity checks in the former.  We'd missed noticing this partly
because none of those checks would fail in scenarios we customarily
test, and partly because the oversight would be masked if both
segments execute, which they would in cases other than needing to
autodetect the format of a non-seekable stdin source.  However,
in a case meeting all these requirements --- for example, trying
to read a newer-than-supported archive format from non-seekable
stdin --- pg_restore missed applying the version check and would
likely dump core or otherwise misbehave.

The whole thing is silly anyway, because there seems little reason
to duplicate the logic beyond the one-line verification that the
file starts with "PGDMP".  There seems to have been an undocumented
assumption that multiple major formats (major enough to require
separate reader modules) would nonetheless share the first half-dozen
fields of the custom-format header.  This seems unlikely, so let's
fix it by just nuking the duplicate logic in _discoverArchiveFormat().

Also get rid of the pointless attempt to seek back to the start of
the file after successful autodetection.  That wastes cycles and
it means we have four behaviors to verify not two.

Per bug #16951 from Sergey Koposov.  This has been broken for
decades, so back-patch to all supported versions.

Discussion: https://postgr.es/m/16951-a4dd68cf0de23048@postgresql.org

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/35421a470de16565e5dca87dc4e2b76fa19c7d08

Modified Files
--------------
src/bin/pg_dump/pg_backup_archiver.c | 137 ++++++++++-------------------------
src/bin/pg_dump/pg_backup_archiver.h |  18 +++--
src/bin/pg_dump/pg_backup_tar.c      |   6 --
3 files changed, 51 insertions(+), 110 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Fix internal extract(timezone_minute) formulas
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: amcheck: Fix verify_heapam's tuple visibility checking rules.