From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'arnaud gaboury *EXTERN*'" <arnaud(dot)gaboury(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgresql-ctl systemd failed: permission denied |
Date: | 2015-07-28 11:31:56 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B50F878A4@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2015-07-28 11:37:27 | Re: postgresql-ctl systemd failed: permission denied |
Previous Message | arnaud gaboury | 2015-07-28 11:31:29 | Re: postgresql-ctl systemd failed: permission denied |