On 6/6/21 10:02 AM, Vijaykumar Jain wrote:
Yes, I learnt it the hard way as well :) I made changes via the alter
system, and did a pg_restore, and the changes were lost :)
use the alter system for ad hoc changes, but make sure those changes are
added back to the postgresql.conf file immediately (or however the main
conf file is managed).
I would suggest taking a look at 'includes':
https://www.postgresql.org/docs/13/config-setting.html#CONFIG-INCLUDES
On Sun, 6 Jun 2021 at 22:17, Tom Lane <tgl@xxxxxxxxxxxxx
<mailto:tgl@xxxxxxxxxxxxx>> wrote:
RAJAMOHAN <garajamohan@xxxxxxxxx <mailto:garajamohan@xxxxxxxxx>> writes:
> I am trying to keep a symbolic link for the
*postgresql.auto.conf* outside
> the data directory. The link gets created but whenever I issue an
alter
> system statement it gets broken.
This is not supported. Don't do it.
The right way to keep the hand-maintained config files outside the
data directory is not the way you've done it here, either. It might
accidentally work, but the preferred way is to put "data_directory =
whatever" in postgresql.conf and then start the postmaster with -D
pointing at where the config files are.
But in any case, postgresql.auto.conf is not hand-maintained; it
is part of the cluster data, so it belongs in the data directory.
regards, tom lane
--
Thanks,
Vijay
Mumbai, India
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
