Search Postgresql Archives

Re: postgresql-ctl systemd failed: permission denied

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

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



--

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux