modify postgresql.conf

Started by Tom Smithover 10 years ago3 messagesgeneral
Jump to latest
#1Tom Smith
tomsmith1989sk@gmail.com

Hi,

Can setting be appended to the end of the postgresql.conf
so that it will override whatever is already in the previous version.
For example

the existing postgresql.conf already has setting

max_connections = 100

in the middle of file.

Now I append a line as the end of the file, regardless what is set already
max_connections = 500

will this setting at the end of the file be guranteed effective value?

I am trying to do this way as I want keep all my changes at the end of the
file
in one place for easy maintenance.

Thanks

#2Michael Paquier
michael@paquier.xyz
In reply to: Tom Smith (#1)
Re: modify postgresql.conf

On Mon, Sep 7, 2015 at 12:12 PM, Tom Smith <tomsmith1989sk@gmail.com> wrote:

Hi,

Can setting be appended to the end of the postgresql.conf
so that it will override whatever is already in the previous version.
For example

the existing postgresql.conf already has setting

max_connections = 100

in the middle of file.

Now I append a line as the end of the file, regardless what is set already
max_connections = 500

will this setting at the end of the file be guranteed effective value?

I am trying to do this way as I want keep all my changes at the end of the
file
in one place for easy maintenance.

The last value read for a parameter is the effective one. This counts
as well for included configuration files. The configuration file
managed by ALTER SYSTEM has the priority over the rest.
--
Michael

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

#3Tom Smith
tomsmith1989sk@gmail.com
In reply to: Michael Paquier (#2)
Re: modify postgresql.conf

Got it. Thanks very much

On Sun, Sep 6, 2015 at 11:25 PM, Michael Paquier <michael.paquier@gmail.com>
wrote:

Show quoted text

On Mon, Sep 7, 2015 at 12:12 PM, Tom Smith <tomsmith1989sk@gmail.com>
wrote:

Hi,

Can setting be appended to the end of the postgresql.conf
so that it will override whatever is already in the previous version.
For example

the existing postgresql.conf already has setting

max_connections = 100

in the middle of file.

Now I append a line as the end of the file, regardless what is set

already

max_connections = 500

will this setting at the end of the file be guranteed effective value?

I am trying to do this way as I want keep all my changes at the end of

the

file
in one place for easy maintenance.

The last value read for a parameter is the effective one. This counts
as well for included configuration files. The configuration file
managed by ALTER SYSTEM has the priority over the rest.
--
Michael