Re: More issues with pg_verify_checksums and checksum verificationin base backups

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: More issues with pg_verify_checksums and checksum verificationin base backups
Дата
Msg-id
20181127230121.GQ1716@paquier.xyz
Ответ на
Список
Дерево обсуждения
More issues with pg_verify_checksums and checksum verification inbase backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verification inbase backups David Steele <david@pgmasters.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Andres Freund <andres@anarazel.de>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verification inbase backups David Steele <david@pgmasters.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Banck <michael.banck@credativ.de>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Andres Freund <andres@anarazel.de>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verification inbase backups Magnus Hagander <magnus@hagander.net>
Re: More issues with pg_verify_checksums and checksum verification inbase backups Stephen Frost <sfrost@snowman.net>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
Patch to avoid SIGQUIT accident Renato dos Santos <shazaum@gmail.com>
Re: Patch to avoid SIGQUIT accident Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to avoid SIGQUIT accident Christoph Berg <myon@debian.org>
Re: Patch to avoid SIGQUIT accident Robert Haas <robertmhaas@gmail.com>
Re: Patch to avoid SIGQUIT accident Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to avoid SIGQUIT accident Renato dos Santos <shazaum@gmail.com>
Re: More issues with pg_verify_checksums and checksum verification inbase backups Amit Kapila <amit.kapila16@gmail.com>
Re: More issues with pg_verify_checksums and checksum verificationin base backups Michael Paquier <michael@paquier.xyz>
On Tue, Nov 27, 2018 at 05:45:41PM -0500, Stephen Frost wrote:
> This doesn't exactly change my opinion regarding this discussion and I'd
> rather we revert the "whitelist" patch and use the very minimal patch
> from here:
> 
> https://www.postgresql.org/message-id/20181012013918.GA30064%40paquier.xyz

Believe me or not, but we have spent so much energy on this stuff that I
am ready to give up on the whitelist patch and focus on other business.
This doesn't change a couple of things though, so it is not *just* a
simple revert with the patch you mention applied:
- Adding a test for tablespaces makes sense.
- skipfile should be called after making sure that we work on a file.
- temporary files and temporary paths should be ignored.
- it is necessary to exclude EXEC_BACKEND files.
--
Michael
В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
От: Thomas Munro
Дата:
FAQ