From: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "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:37:27 |
Message-ID: | CAK1hC9smdSxpk_Doj7BVeSXJLRjP6MDqF3efk2nXad_euWb4Lw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jul 28, 2015 at 1:31 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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>
From | Date | Subject | |
---|---|---|---|
Next Message | CaT | 2015-07-28 11:43:32 | Re: postgresql-ctl systemd failed: permission denied |
Previous Message | Albe Laurenz | 2015-07-28 11:31:56 | Re: postgresql-ctl systemd failed: permission denied |