Re: Symbolic link breaks for postgresql.auto.conf

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(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
>
> RAJAMOHAN <garajamohan(at)gmail(dot)com <mailto:garajamohan(at)gmail(dot)com>> 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(dot)klaver(at)aklaver(dot)com