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

From Tom Lane
Subject Re: Checkpoint request failed, permission denied
Date
Msg-id 16110.1252938594@sss.pgh.pa.us
Whole thread Raw
In response to Checkpoint request failed, permission denied  (Cory Isaacson <cory.isaacson@compuflex.com>)
Responses Re: Checkpoint request failed, permission denied
List pgsql-general
Cory Isaacson <cory.isaacson@compuflex.com> writes:
> When I try and manually perform a checkpoint with version 8.3 on CentOS 5 I
> get this error:

> ERROR:  could not link file "pg_xlog/000000010000000000000000" to
> "pg_xlog/000000010000000000000002" (initialization of log file 0, segment
> 2): Permission denied

> Any ideas what is causing this? The pg_xlog dir is owned by the postgres
> user, as are the log files. Also I have temporarily disabled SELinux to make
> sure that is not causing it.

It's very hard to see how that could be anything except an
ownership/permissions problem on the pg_xlog directory.  Are you sure
the directory is mode 700 as well as being owned by postgres?
(For that matter, are you sure the postmaster is running as postgres?)
Are you *really* sure selinux is disabled?

            regards, tom lane

pgsql-general by date:

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