Re: postgresql-ctl systemd failed: permission denied

On Tue, Jul 28, 2015 at 1:26 PM, Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:

> Hi Arnaud...
>
> On Tue, Jul 28, 2015 at 12:13 PM, arnaud gaboury
> <arnaud(dot)gaboury(at)gmail(dot)com> wrote:
> > On Fedora 22
> ...
> > 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/
>
> May be stating the obvious, but can you try 'touch
> /storage/log/postgresql/postgresql-Tue.log" as postgres to see it it
> works.

% ls -al /storage/log/postgresql
total 0
drwxrwxr-x 1 postgres postgres 36 Jul 28 13:27 ./
drwxr-x--- 1 root wheel 208 Jul 27 13:34 ../
-rw-rw-r-- 1 postgres postgres 0 Jul 28 13:27 postgresql-Tue.log

Still permission denied

> Also, doing the ls -al on /storage/log/postgresql, in case it
> has a previous read only file for Tue, and may be even a lsattr on the
> paths

# lsattr /storage/log
---------------- /storage/log/django_slacklog
---------------- /storage/log/wiki
---------------- /storage/log/nginx
---------------- /storage/log/php-fpm
---------------- /storage/log/phppgadmin
---------------- /storage/log/postgresql
---------------- /storage/log/xdebug
---------------- /storage/log/psqlStat
---------------- /storage/log/psqlReport
---------------- /storage/log/dovecot
---------------- /storage/log/vsftpd
---------------- /storage/log/fail2ban
---------------- /storage/log/wtmp
---------------- /storage/log/btmp

( listing the fs type will be useful too, maybe Fedora is using
> some extended thingies ).
>
> Francisco Olarte.
>

--

google.com/+arnaudgabourygabx
<https://plus.google.com/_/notifications/emlink?emr=05814804238976922326&emid=CKiv-v6PvboCFcfoQgod6msAAA&path=%2F116159236040461325607%2Fop%2Fu&dt=1383086841306&ub=50>