BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf

Started by PG Bug reporting form2 months ago4 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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'.

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf

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.

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: David G. Johnston (#2)
Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf

"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

#4Jürgen Schmidt
jsschmidthb@gmail.com
In reply to: Tom Lane (#3)
Re: BUG #19691: Wrong configuration in .../Postgres/var-19/postgresql.auto.conf

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