Re: postgresql-ctl systemd failed: permission denied

On Tue, Jul 28, 2015 at 1:43 PM, CaT <cat(at)zip(dot)com(dot)au> wrote:

> On Tue, Jul 28, 2015 at 01:31:29PM +0200, arnaud gaboury wrote:
> > 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
>
> If the logfile is being written to as the user postgres then .. is what
> is preventing it. Only root and wheel have access so unless postgres is
> in group wheel you need to
>
> chmod o+x /storage/log at least.
>

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

% sudo systemctl status postgresql
...............
Jul 28 13:47:40 poppy systemd[1]: Started PostgreSQL database server.

Thank you so much. Again, permission story

> --
> "A search of his car uncovered pornography, a homemade sex aid, women's
> stockings and a Jack Russell terrier."
> -
> http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480
>

--

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