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

From Jürgen Schmidt
Subject Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
Date
Msg-id CAPNnfixzZE-=PeJEc0CCfLTiYWDwv=e6uesUxM-2favq4dwaKQ@mail.gmail.com
Whole thread
In response to Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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:
"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: Tom Lane
Date:
Subject: Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf
Next
From: Jeff Davis
Date:
Subject: TID Range Scans can return wrong results after scanning backwards