Re: Checkpoint request failed, permission denied - Mailing list pgsql-general

From Tom Lane
Subject Re: Checkpoint request failed, permission denied
Date
Msg-id 17279.1252944588@sss.pgh.pa.us
Whole thread Raw
In response to Re: Checkpoint request failed, permission denied  (Cory Isaacson <cory.isaacson@compuflex.com>)
Responses Re: Checkpoint request failed, permission denied  (Cory Isaacson <cory.isaacson@compuflex.com>)
List pgsql-general
Cory Isaacson <cory.isaacson@compuflex.com> writes:
> Here are the permissions on pg_xlog:
> drwx------ 3 postgres postgres  4096 Sep 13 22:19 pg_xlog

Well, that certainly looks right.  I'm back to suspecting selinux ...
have you tried "ls -Z"?  I'm not totally sure about RHEL5, but in
recent Fedora it should look like

drwx------. postgres postgres unconfined_u:object_r:postgresql_db_t:s0 pg_xlog

the "postgresql_db_t" bit being the actually critical part.

            regards, tom lane

pgsql-general by date:

Previous
From: Cory Isaacson
Date:
Subject: Re: Checkpoint request failed, permission denied
Next
From: Tom Lane
Date:
Subject: Re: postgresql.key secure storage