[GENERAL] Postgres runs under other user/group, update crashs installation

Поиск
Список
Период
Сортировка
От pillul@freenet.de
Тема [GENERAL] Postgres runs under other user/group, update crashs installation
Дата
Msg-id 0aa259dcfe2eed9c77da8ee9489578e4@email.freenet.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: [GENERAL] pg_repack and Postgres versions > 9.4
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [GENERAL] Recursive row level security policy