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 getfattr -d /storage/log/postgresql Maybe some weird permissions or attributes are set. Another idea: the file system could be mounted read-only. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
