BUG #11595: PostgreSQL applies intermediate configuration files - Mailing list pgsql-bugs

From kyanh@theslinux.org
Subject BUG #11595: PostgreSQL applies intermediate configuration files
Date
Msg-id 20141006042524.2565.17347@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #11595: PostgreSQL applies intermediate configuration files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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]

pgsql-bugs by date:

Previous
From: Walter Willmertinger
Date:
Subject: Re: BUG #11550: Error messages contain not encodable characters (Latin9)
Next
From: kotadiyadhrupesh@gmail.com
Date:
Subject: BUG #11596: Duplicate column