On Tue, Jul 28, 2015 at 1:37 PM, arnaud gaboury <arnaud.gabo...@gmail.com> wrote:
> > > On Tue, Jul 28, 2015 at 1:31 PM, Albe Laurenz <laurenz.a...@wien.gv.at> > wrote: > >> 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 google.com/+arnaudgabourygabx <https://plus.google.com/_/notifications/emlink?emr=05814804238976922326&emid=CKiv-v6PvboCFcfoQgod6msAAA&path=%2F116159236040461325607%2Fop%2Fu&dt=1383086841306&ub=50>
