Title: 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.isaacson@xxxxxxxxxxxxx>
Date: Sun, 13 Sep 2009 21:57:50 -0600
To: <pgsql-general@xxxxxxxxxxxxxx>
Subject: 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
