Re: postgresql-ctl systemd failed: permission denied

On Tue, Jul 28, 2015 at 1:37 PM, arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>
wrote:

>
>
> 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
>
>
> 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>