BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
The following bug has been logged on the website:
Bug reference: 19691
Logged by: Jürgen Schmidt
Email address: jsschmidthb@gmail.com
PostgreSQL version: 19beta3
Operating system: macOS Tahoe 26.6.2
Description:
The wrong line: shared_preload_libraries =
'"auth_permission_dialog,pg_stat_statements"':
The quotation marks must be removed.
The right line: shared_preload_libraries =
'auth_permission_dialog,pg_stat_statements'.
On Wednesday, September 16, 2026, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 19691
Logged by: Jürgen Schmidt
Email address: jsschmidthb@gmail.com
PostgreSQL version: 19beta3
Operating system: macOS Tahoe 26.6.2
Description:The wrong line: shared_preload_libraries =
'"auth_permission_dialog,pg_stat_statements"':The quotation marks must be removed.
The right line: shared_preload_libraries =
'auth_permission_dialog,pg_stat_statements'.
Seems more likely to be operator error than a bug.
David J.
"David G. Johnston" <david.g.johnston@gmail.com> writes:
On Wednesday, September 16, 2026, PG Bug reporting form <
noreply@postgresql.org> wrote:The wrong line: shared_preload_libraries =
'"auth_permission_dialog,pg_stat_statements"':
The quotation marks must be removed.
Seems more likely to be operator error than a bug.
Specifically, that is what you'd get from
alter system set shared_preload_libraries = 'auth_permission_dialog,pg_stat_statements';
Correct syntax is
alter system set shared_preload_libraries = auth_permission_dialog,pg_stat_statements;
You could quote the individual list items if you felt a need to:
alter system set shared_preload_libraries = 'auth_permission_dialog', 'pg_stat_statements';
but as-is you wrote a single list item that happens to contain a
comma.
regards, tom lane
Thank you very much for the prompt responses and for your time.
Best regards, Juergen Schmidt
On Wed, 16 Sept 2026 at 16:13, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
"David G. Johnston" <david.g.johnston@gmail.com> writes:
On Wednesday, September 16, 2026, PG Bug reporting form <
noreply@postgresql.org> wrote:The wrong line: shared_preload_libraries =
'"auth_permission_dialog,pg_stat_statements"':
The quotation marks must be removed.Seems more likely to be operator error than a bug.
Specifically, that is what you'd get from
alter system set shared_preload_libraries =
'auth_permission_dialog,pg_stat_statements';Correct syntax is
alter system set shared_preload_libraries =
auth_permission_dialog,pg_stat_statements;You could quote the individual list items if you felt a need to:
alter system set shared_preload_libraries = 'auth_permission_dialog',
'pg_stat_statements';but as-is you wrote a single list item that happens to contain a
comma.regards, tom lane