Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
Date
Msg-id 496582.1789568023@sss.pgh.pa.us
Whole thread
In response to Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
List pgsql-bugs
"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



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
Next
From: Jürgen Schmidt
Date:
Subject: Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf