Re: Checkpoint request failed, permission denied

I should note that this came up when I tried to drop a database. It was not
allowed with the checkpoint failed message.

Cory

From: Cory Isaacson <cory(dot)isaacson(at)compuflex(dot)com>
Date: Sun, 13 Sep 2009 21:57:50 -0600
To: <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Checkpoint request failed, permission denied

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
ERROR: could not link file "pg_xlog/000000010000000000000000" to
"pg_xlog/000000010000000000000002" (initialization of log file 0, segment
2): Permission denied
ERROR: checkpoint request failed
HINT: Consult recent messages in the server log for details.

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.

Thanks,

Cory