Thanks guys.
Able to resolve the issue, by using the include_if_exists parameter as
Adrian suggested.
Thanks & Regards,
Rajamohan.J
On Mon, Jun 7, 2021 at 1:02 AM Adrian Klaver
wrote:
> On 6/6/21 10:50 AM, Vijaykumar Jain wrote:
>
> Please reply to list also.
> Ccing list
>
> Also please use
On 6/6/21 10:50 AM, Vijaykumar Jain wrote:
Please reply to list also.
Ccing list
Also please use inline or bottom posting, it makes things easier to follow.
Yeah I am aware of that :)
I was referring to if the main config is managed via some config
management tool like puppet, ansible or an
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 immediate
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).
RAJAMOHAN 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
On 6/6/21 9:00 AM, RAJAMOHAN wrote:
Hello all,
Can someone explain how *postgresql.auto.conf *file contents gets
updated, when running an alter system statement followed by pg_reload_conf?
I am trying to keep a symbolic link for the
*postgresql.auto.conf* outside the data directory. The link
Hello all,
Can someone explain how *postgresql.auto.conf *file contents gets updated,
when running an alter system statement followed by pg_reload_conf?
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 alt
