Обсуждение: Proposal: Allow excluding specific file patterns in pg_checksums

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

Proposal: Allow excluding specific file patterns in pg_checksums

От
XYenon
Дата:
Hi,

I’ve hit the same issue as PGroonga GitHub Issue #233 [1]:
PGroonga-related files trigger pg_checksums verification
failures.

I’d like to propose a feature: Add support to pg_checksums for
excluding files matching custom patterns. This can handle
compatibility with extensions like PGroonga that generate files
within the PostgreSQL data directory.

Best regards,
XYenon

[1] https://github.com/pgroonga/pgroonga/issues/233



Re: Proposal: Allow excluding specific file patterns in pg_checksums

От
Greg Sabino Mullane
Дата:
Putting files inside base/ is just a bad idea. Even if you handle pg_checksums and pg_basebackup, external tools like pgbackrest will have issues as well. I think better solutions are one of:

* Store these non-Postgres files somewhere else. Can still be in the data directory
* Make sure the files have valid checksums

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

Re: Proposal: Allow excluding specific file patterns in pg_checksums

От
Daniel Gustafsson
Дата:
> On 23 Oct 2025, at 16:39, Greg Sabino Mullane <htamfids@gmail.com> wrote:
>
> Putting files inside base/ is just a bad idea. Even if you handle pg_checksums and pg_basebackup, external tools like
pgbackrestwill have issues as well. 

Agreed.

--
Daniel Gustafsson