Re: Postgresql.conf group ownership changed automatically - Mailing list pgsql-admin

From Mukesh Rajpurohit
Subject Re: Postgresql.conf group ownership changed automatically
Date
Msg-id CAL+ptABm94H3gJfY9DDaSRVwbuSVf7YmMNNyqpLq=LfotSf9CQ@mail.gmail.com
Whole thread Raw
In response to Postgresql.conf group ownership changed automatically  (Mukesh Rajpurohit <vivasvan1902@gmail.com>)
List pgsql-admin
Please note that pg_reload_conf() was successful and also I am not able to reproduce this issue in test server.

Thanks
Mukesh

On Thu, Sep 2, 2021, 9:38 AM Mukesh Rajpurohit <vivasvan1902@gmail.com> wrote:
Hi,
         We have linux host server and use docker container in it for hosting of  postgresql 12 version database. Its postgresql.conf file ownership was postgres:postgres in container server and it was working fine.

Recently I did a timezone parameter change in the postgresql.conf file and then did pg_reload_conf() from pgadmin. Now, postgresql.conf file group ownership has changed automatically to some numeric number which is not available in /etc/group too.  However, file ownership is postgres only and db is working.

I can do "chgrp postgres postgresql.conf" online but as it is a containerized database it may be sensitive to such changes so I want to be sure that this change would not adversely impact the container.

Please let me know if someone encountered such an issue and solution to it.

Thanks
Mukesh 

pgsql-admin by date:

Previous
From: Mukesh Rajpurohit
Date:
Subject: Postgresql.conf group ownership changed automatically
Next
From: Atul Kumar
Date:
Subject: Re: vacuumlo