Postgres runs under other user/group, update crashs installation

From: pillul(at)freenet(dot)de
To:
Subject: Postgres runs under other user/group, update crashs installation
Date: 2016-12-16 14:35:56
Message-ID: 0aa259dcfe2eed9c77da8ee9489578e4@email.freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 postgresgroupdel postgreschown newuser.newgroup /var/run/postgresql -Rchown newuser.newgroup /var/lib/pgsql -R systemctl edit postgresql.servicecontent:[Service]User=newuserGroup=newgroupThis 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!

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2016-12-16 14:36:27 Re: Recursive row level security policy
Previous Message Kenneth Marshall 2016-12-16 14:29:40 Re: pg_repack and Postgres versions > 9.4