Moving pg_xlog to another drive

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving pg_xlog to another drive
Date: 2007-06-04 17:44:38
Message-ID: Pine.LNX.4.64.0706041038020.27105@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

This is on CentOS 5 with the latest RPMs. SELinux is not enforcing (nor
logging any events when I do this stuff).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-04 18:02:41 Re: pg_dump: ERROR: could not open relation with OID ...
Previous Message Zoltan Boszormenyi 2007-06-04 17:18:45 Re: NULLS and User Input WAS Re: multimaster