Re: [GENERAL] Checkpoint request failed, permission denied

2009-09-14 Thread Cory Isaacson
pg_xlog -rw--- postgres postgres root:object_r:postgresql_db_t 0001 drwx-- postgres postgres root:object_r:postgresql_db_t archive_status > From: Tom Lane > Date: Mon, 14 Sep 2009 12:09:48 -0400 > To: Cory Isaacson > Cc: > Subject: Re: [GENERAL] Che

Re: [GENERAL] Checkpoint request failed, permission denied

2009-09-14 Thread Cory Isaacson
postgres: itt itt_dev 127.0.0.1(49593) idle postgres 26879 25752 0 00:22 ?00:00:00 postgres: itt itt_dev 127.0.0.1(49595) idle > From: Tom Lane > Date: Mon, 14 Sep 2009 10:29:54 -0400 > To: Cory Isaacson > Cc: > Subject: Re: [GENERAL] Checkpoint request failed, permission d

Re: [GENERAL] Checkpoint request failed, permission denied

2009-09-14 Thread Cory Isaacson
To: Cory Isaacson > Cc: > Subject: Re: [GENERAL] Checkpoint request failed, permission denied > > Cory Isaacson writes: >> They look right to me. Below are the permissions and process list. I ended >> up rebuilding the data directory since it was just a test database, s

Re: [GENERAL] Checkpoint request failed, permission denied

2009-09-14 Thread Cory Isaacson
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 Date: Sun, 13 Sep 2009 21:57:50 -0600 To: Subject: [GENERAL] Checkpoint request failed, permission denied When I try and manually perform a

[GENERAL] Checkpoint request failed, permission denied

2009-09-14 Thread Cory Isaacson
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/0001" to "pg_xlog/00010002" (initialization of log file 0, segment 2): Permission denied ERROR: could not link file "pg_xlog/000