[GENERAL] Postgres runs under other user/group, update crashs installation - Mailing list pgsql-general

From pillul@freenet.de
Subject [GENERAL] Postgres runs under other user/group, update crashs installation
Date
Msg-id 0aa259dcfe2eed9c77da8ee9489578e4@email.freenet.de
Whole thread Raw
List pgsql-general

 

Hey Folks,

we use postgres from the actual RHEL 7 repo.
I installed it some weeks ago and changed the user/group under which the service
runs via systemd:
userdel postgres
groupdel postgres
chown newuser.newgroup /var/run/postgresql -R
chown newuser.newgroup /var/lib/pgsql -R
 
systemctl edit postgresql.service
content:
[Service]
User=newuser
Group=newgroup
This works like a charm, until i updated to 9-2-18 yesterday.
In the back to postgres.postgres. 
Which lead to a postgres instance which couldnt start anymore because "newuser" can access the files....
How can i configure postgres so it doesnt break while updating?
Thanks a lot!


---
Die Bundesliga hat begonnen! Alle Tore, alle Ergebnisse, alle News: Pocket Liga jetzt im AppStore oder Google Play Store herunterladen - kostenlos!

pgsql-general by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] pg_repack and Postgres versions > 9.4
Next
From: Joe Conway
Date:
Subject: Re: [GENERAL] Recursive row level security policy