ownership of /var/lib/postgresql should be given to postgres user
I got an issue when using the postgres user to connect to postgresql :
could not save history to file “/var/lib/postgresql/.psql_history”:
Permission denied
The reason being that /var/lib/postgresql is owned by root, not by postgres
ubuntu had the same issue in the past : https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1334714
Thanks
(from redmine: issue id 5024, created on 2016-01-15, closed on 2016-05-31)
- Changesets:
- Revision 8254de6f by Natanael Copa on 2016-05-26T08:30:00Z:
main/postgresql: create homedir for postgres user
fixes #5024