BUG #11595: PostgreSQL applies intermediate configuration files

Started by Anh K. Huynhover 11 years ago3 messagesbugs
Jump to latest
#1Anh K. Huynh
kyanh@theslinux.org

The following bug has been logged on the website:

Bug reference: 11595
Logged by: Anh Huynh
Email address: kyanh@theslinux.org
PostgreSQL version: 9.3.5
Operating system: Ubuntu 14.04 LTS
Description:

Problem
=======

When a configuration directive is declared multiple times, PostgreSQL will
apply the intermediate configuration and generate useless error message.

Expected behavior
=================

PostgresSQL uses the last declaration of a setting in its configuration.

Proof of the problem
====================

[code]
$ sudo cat /etc/postgresql/9.3/main/conf.d.no-puppet/log.conf

log_line_prefix = '1 [%t] '
log_line_prefix = '2 [%t] '
log_line_prefix = '3 [%t] '

$ sudo /etc/init.d/postgresql reload
* Reloading PostgreSQL 9.3 database server
...done.

$ grep log_line_prefix /var/log/postgresql/postgresql-9.3-main.log

1 [2014-10-06 03:39:53 UTC] LOG: parameter "log_line_prefix" changed to "1
[%t] "
2 [2014-10-06 03:39:53 UTC] LOG: parameter "log_line_prefix" changed to "2
[%t] "
3 [2014-10-06 03:39:53 UTC] LOG: parameter "log_line_prefix" changed to "3
[%t] "

[/code]

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Anh K. Huynh (#1)
Re: BUG #11595: PostgreSQL applies intermediate configuration files

kyanh@theslinux.org writes:

When a configuration directive is declared multiple times, PostgreSQL will
apply the intermediate configuration and generate useless error message.

This is fixed for 9.4. Thanks for the report though!

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#3Anh K. Huynh
kyanh@theslinux.org
In reply to: Tom Lane (#2)
Re: BUG #11595: PostgreSQL applies intermediate configuration files

On Mon, 06 Oct 2014 15:13:04 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

kyanh@theslinux.org writes:

When a configuration directive is declared multiple times,
PostgreSQL will apply the intermediate configuration and generate
useless error message.

This is fixed for 9.4. Thanks for the report though!

regards, tom lane

Thanks for your feedback, and I'm sorry for my duplicate report.

Regards,

--
I am ... 5.5 dog years old.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs