postgresql-ctl systemd failed: permission denied

From: arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgresql-ctl systemd failed: permission denied
Date: 2015-07-28 10:13:06
Message-ID: CAK1hC9sMTOGEW1gftNiqczp-B8iNj3VrBC6dGHhV2tz2_kOBxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thank you
--

google.com/+arnaudgabourygabx

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2015-07-28 11:26:04 Re: postgresql-ctl systemd failed: permission denied
Previous Message Herouth Maoz 2015-07-28 07:27:11 Re: *SOLVED* Connections closing due to "terminating connection due to administrator command"