Re: Permissions on postgresql.conf, psql and patroni

2019-09-09 Thread Peter J. Holzer
On 2019-09-09 19:15:19 +0200, Peter J. Holzer wrote: > On 2019-09-09 10:03:57 -0400, Tom Lane wrote: > > "Peter J. Holzer" writes: > > > Yesterday I "apt upgrade"d patroni (to version 1.6.0-1.pgdg18.04+1 > > > from http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main). > > > Today I noticed th

Re: Permissions on postgresql.conf, psql and patroni

2019-09-09 Thread Peter J. Holzer
On 2019-09-09 13:29:38 +0200, Daniel Verite wrote: > Peter J. Holzer wrote: > > 2) Why does psql need to read postgresql.conf, and more specifically, > > why does it care about the location of the data directory? It > > shouldn't access files directly, just talk to the server via the > >

Re: Permissions on postgresql.conf, psql and patroni

2019-09-09 Thread Tom Lane
"Peter J. Holzer" writes: > Yesterday I "apt upgrade"d patroni (to version 1.6.0-1.pgdg18.04+1 from > http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main). > Today I noticed that I couldn't invoke psql as an unprivileged user > anymore: > % psql > Error: Invalid data directory for cluster 11

Re: Permissions on postgresql.conf, psql and patroni

2019-09-09 Thread Daniel Verite
Peter J. Holzer wrote: > 2) Why does psql need to read postgresql.conf, and more specifically, > why does it care about the location of the data directory? It > shouldn't access files directly, just talk to the server via the > socket. It's not psql itself, it's pg_wrapper. $ ls -l

Permissions on postgresql.conf, psql and patroni

2019-09-09 Thread Peter J. Holzer
Yesterday I "apt upgrade"d patroni (to version 1.6.0-1.pgdg18.04+1 from http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main). Today I noticed that I couldn't invoke psql as an unprivileged user anymore: % psql Error: Invalid data directory for cluster 11 main Further investigation showed th