Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
От | Basha |
---|---|
Тема | Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications |
Дата | |
Msg-id | GV1P194MB2356A3AED4F276E1AD0E6162D89E2@GV1P194MB2356.EURP194.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
|
Список | pgsql-bugs |
The original option to allow system table is to make changes to the system tables. This change in 16.4 is removing that feature. When allow system table is set to on, this new feature should still allow and should not affect anything.
Regards,
Basha
Sent from Outlook for Android
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Friday, September 6, 2024 7:49:07 PM
To: Basha <basha@maxcontact.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
Sent: Friday, September 6, 2024 7:49:07 PM
To: Basha <basha@maxcontact.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: [EXT]: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents Essential System Table Modifications
[You don't often get email from tgl@sss.pgh.pa.us. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]
PG Bug reporting form <noreply@postgresql.org> writes:
> Steps to Reproduce:
> Enable allow_system_table_mods = true.
> Modify system tables (e.g., pg_database) to restrict visibility in a
> multi-tenant setup.
> Attempt to run pg_dump for backup purposes.
> pg_dump fails due to the recent security restriction.
Without any details about what you did to the system catalogs,
this complaint is quite un-actionable.
I will note that we do not consider random manual changes to
system catalogs to be a supported feature.
regards, tom lane
PG Bug reporting form <noreply@postgresql.org> writes:
> Steps to Reproduce:
> Enable allow_system_table_mods = true.
> Modify system tables (e.g., pg_database) to restrict visibility in a
> multi-tenant setup.
> Attempt to run pg_dump for backup purposes.
> pg_dump fails due to the recent security restriction.
Without any details about what you did to the system catalogs,
this complaint is quite un-actionable.
I will note that we do not consider random manual changes to
system catalogs to be a supported feature.
regards, tom lane
В списке pgsql-bugs по дате отправления: