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
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
Cory Isaacson writes:
> Here are the permissions on pg_xlog:
> drwx-- 3 postgres postgres 4096 Sep 13 22:19 pg_xlog
Well, that certainly looks right. I'm back to suspecting selinux ...
have you tried "ls -Z"? I'm not totally sure about RHEL5, but in
recent Fedora it should look like
drwx-
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
On Mon, Sep 14, 2009 at 8:52 AM, Cory Isaacson
wrote:
> [r...@ittdev1 data]# ls -l pg_xlog
> total 16416
> -rw--- 1 postgres postgres 16777216 Sep 13 23:16
> 0001
> drwx-- 2 postgres postgres 4096 Sep 13 22:19 archive_status
What odes ls -ld pg_xlog say?
--
Sent
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, so far
> so good. The permissions and setup were exactly the same before I did this.
> [r...@ittdev1 data]# ls -l pg_xlog
This
Cory Isaacson writes:
> I think you may be right. There were some audit access denied messages. I
> had SELinux in permissive mode, but its tricky to work with.
> I generated a new SELinux rule using audit2allow, here is what it looks like
> now. Do you think this is adequate?
If you're keeping
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
Cory Isaacson 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/0001" to
> "pg_xlog/00010002" (initialization of log file 0, segment
> 2): Permission denied
> Any idea
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
10 matches
Mail list logo
