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:31 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
arnaud gaboury wrote:
> 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?

What file system is that? ext4?

What do you get for:
  ls -l /storage/log/postgresql/postgresql-Tue.log
Perhaps the file exists and you don't have permissions to open it.

If not, does the following succeed as user "postgres":
  touch /storage/log/postgresql/postgresql-Tue.log
Do you get the same error message?

What do you get for:
  getfacl -p /storage/log/postgresql

 % getfacl -p /storage/log/postgresql
# file: /storage/log/postgresql
# owner: postgres
# group: postgres
user::rwx
group::rwx
other::r-x

  getfattr -d /storage/log/postgresql
Maybe some weird permissions or attributes are set.

Another idea: the file system could be mounted read-only.

No, it has been working for long until recently.  
% egrep " ro,|,ro " /proc/mounts does not return the path


Yours,
Laurenz Albe



--

[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