postgresql.conf evaluation of duplicate keys

From: Martin Gerdes <martin(dot)gerdes(at)dser(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql.conf evaluation of duplicate keys
Date: 2012-03-21 14:02:15
Message-ID: 4F69DF67.5080005@dser.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a question relating to how the postgres configuration is parsed:

If I write into the following into postgresql.conf:
shared_buffers = 24MB
shared_buffers = 32MB

and start up postgres, the command 'show shared_buffers;' answers
'32MB'. That means the later value in the configuration file took
precedence. Which is great and what I would expect.
Now the question: Is this just a happy accident and could change at any
time, or is this documented and guaranteed behaviour (and if so, can you
point me to the relevant documentation)? I tried to search for it, but
my google foo is just not strong enough :-)

Answer to the (probably) inevitable question: "What are you trying to
achieve?" :
I am trying to define a set of defaults, which will get deployed to
multiple servers, and will be overwritten automatically. Yet I also want
to have the option to change individual parameters on one server. So I
want to introduce a line "#==do not modify above this line==".
Everything above the line will be replaced, everything below it left
untouched.
So if postgres is actually also parsing a file "postgresql.local" whose
values are guaranteed to take precedence over "postgresql.conf", that
would solve my problem as well.

Many thanks in advance!

Martin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message C. Bensend 2012-03-21 14:13:35 Re: POSTGRESQL Newbie
Previous Message Andrew Sullivan 2012-03-21 13:55:13 Re: POSTGRESQL Newbie