arnaud gaboury wrote: > On Fedora 22 > > % pg_ctl -V > pg_ctl (PostgreSQL) 9.4.4 > > ---------------------------------------------------------------- > % systemctl status postgresql.service -l > ● postgresql.service - PostgreSQL database server > Loaded: loaded (/etc/systemd/system/postgresql.service; enabled; > vendor preset: disabled) > Active: failed (Result: exit-code) since Tue 2015-07-28 11:50:01 > CEST; 19min ago > > Jul 28 11:49:56 poppy systemd[1]: Starting PostgreSQL database server... > Jul 28 11:49:57 poppy postgresql-ctl[307]: FATAL: 42501: could not > open log file "/storage/log/postgresql/postgresql-Tue.log": Permission > denied > Jul 28 11:49:57 poppy postgresql-ctl[307]: LOCATION: logfile_open, > syslogger.c:1160 > Jul 28 11:50:01 poppy postgresql-ctl[307]: pg_ctl: could not start server > ---------------------------------------------------------------- > > % ls -al /storage/log > drwxr-xr-x 1 postgres postgres 0 Jul 28 11:29 postgresql/ > > > I have found a few entries on the web but with no clear fix. I even > saw this was a bug. > > Can anyone tell me more and how to fix if it is possible?
What file system is that? ext4?
What do you get for: ls -l /storage/log/postgresql/postgresql-Tue.log Perhaps the file exists and you don't have permissions to open it.
If not, does the following succeed as user "postgres": touch /storage/log/postgresql/postgresql-Tue.log Do you get the same error message?
What do you get for: getfacl -p /storage/log/postgresql
% getfacl -p /storage/log/postgresql
# file: /storage/log/postgresql
# owner: postgres
# group: postgres
user::rwx
group::rwx
other::r-x
getfattr -d /storage/log/postgresql Maybe some weird permissions or attributes are set.
Another idea: the file system could be mounted read-only.
No, it has been working for long until recently.
% egrep " ro,|,ro " /proc/mounts does not return the path
It may be a systemd story. On another machine, with systemd 222, postgresql.service is starting fine. Same permisssions/settings on log directories
On the system with issue, Fedora 22 is running systemd 219.13
