Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql-ctl systemd failed: permission denied - Mailing list pgsql-general

From arnaud gaboury
Subject Re: postgresql-ctl systemd failed: permission denied
Date
Msg-id CAK1hC9tLwhpgT-ux=iCmS10FhWybwxa_N0zrGM0kt1bL5eUPkA@mail.gmail.com
Whole thread Raw
In response to Re: postgresql-ctl systemd failed: permission denied  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: postgresql-ctl systemd failed: permission denied  (CaT <cat@zip.com.au>)
List pgsql-general
Tree view


On Tue, Jul 28, 2015 at 1:26 PM, Francisco Olarte <folarte@peoplecall.com> wrote:
Hi Arnaud...

On Tue, Jul 28, 2015 at 12:13 PM, arnaud gaboury
<arnaud.gaboury@gmail.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.



--

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: postgresql-ctl systemd failed: permission denied
Next
From: Albe Laurenz
Date:
Subject: Re: postgresql-ctl systemd failed: permission denied