Re: Moving pg_xlog to another drive

Поиск
Список
Период
Сортировка
От Ben
Тема Re: Moving pg_xlog to another drive
Дата
Msg-id Pine.LNX.4.64.0706041112540.27105@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Moving pg_xlog to another drive  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Moving pg_xlog to another drive
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: ABHANG RANE
Дата:
Сообщение: COPY error
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: Moving pg_xlog to another drive