Re: Moving pg_xlog to another drive

On Jun 4, 2007, at 11:15 AM, Ben wrote:

> On Mon, 4 Jun 2007, Joshua D. Drake wrote:
>
>> Ben wrote:
>>> I'm trying to move my WAL to another drive, but am having
>>> difficulties with this seemingly simple process. Every time I
>>> start up with pg_xlog symlinked to my other drive, I get this:
>>> FATAL: could not open file "pg_xlog/00000001.history":
>>> Permission denied
>>> If I move pg_xlog back into its normal place then things work
>>> fine. The postgres user can certainly create files when using the
>>> symlink, so I really don't think it's a permission issue... but
>>> I'm at a loss as to what else it might be.
>>
>> Is the parent directory of the place you are moving pg_xlog to a
>> place that the postgres user can enter?
>
> Sorry, yes, I neglected to mention that the postgres user can enter
> every directory along the path to the new pg_xlog directory. In
> addition, pg_xlog remains owned by postgres.postgres, as does its
> parent directory, and the new pg_xlog directory has permissions of
> 0700.
>
> So I really can't see why it would be a permission issue.

Are you running SELinux? It's main goal in life is to break disk
access by denying permission to files anywhere other than where it
thinks an application should be allowed to access.

Cheers,
Steve