modify postgresql.conf
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
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 examplethe 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 = 500will 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
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 examplethe 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