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.isaac...@compuflex.com> Date: Sun, 13 Sep 2009 21:57:50 -0600 To: <pgsql-general@postgresql.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
