FS#63573 - [postgresql] /var/lib/postgres should be owned by user postgres and not by root
Attached to Project:
Arch Linux
Opened by Riri (chicha) - Tuesday, 27 August 2019, 16:14 GMT
Last edited by Buggy McBugFace (bugbot) - Saturday, 25 November 2023, 20:15 GMT
Opened by Riri (chicha) - Tuesday, 27 August 2019, 16:14 GMT
Last edited by Buggy McBugFace (bugbot) - Saturday, 25 November 2023, 20:15 GMT
|
Details
Description:
The postgresql package installs a directory '/var/lib/postgres/data' using a dedicated systemd-tmpfiles configuration file with the following settings : d /var/lib/postgres/data 700 postgres postgres h /var/lib/postgres/data - - - - +C systemd-tmpfile will set ownership to postgres only for the innermost directory '/var/lib/postgres/data' but the parent directory will be owned by root. This is an issue because '/var/lib/postgres' is also the HOME directory for user 'postgres' : such user cannot write psql or bash history files, vim swap files and so ... I believe the file postgresql.tmpfiles from the package should be changed to : d /var/lib/postgres 700 postgres postgres d /var/lib/postgres/data 700 postgres postgres h /var/lib/postgres/data - - - - +C Additional info: * package version(s): postgresql-11.5-1 |
This task depends upon
Closed by Buggy McBugFace (bugbot)
Saturday, 25 November 2023, 20:15 GMT
Reason for closing: Moved
Additional comments about closing: https://gitlab.archlinux.org/archlinux/p ackaging/packages/postgresql/issues/1
Saturday, 25 November 2023, 20:15 GMT
Reason for closing: Moved
Additional comments about closing: https://gitlab.archlinux.org/archlinux/p ackaging/packages/postgresql/issues/1
imo it shouldn't even be a user with an interactive shell to login with, but in average people don't quite seem to be able to handle psql usage with the postgres user without interactive shell