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 Yours, > Laurenz Albe > -- google.com/+arnaudgabourygabx <https://plus.google.com/_/notifications/emlink?emr=05814804238976922326&emid=CKiv-v6PvboCFcfoQgod6msAAA&path=%2F116159236040461325607%2Fop%2Fu&dt=1383086841306&ub=50>
