Re: Moving pg_xlog problem

On Tue, 2005-11-08 at 13:29 -0500, Tom Lane wrote:
> Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> writes:
> > Panoramix:/var/lib/postgresql/8.0/main# ls /opt/ -al
> > total 56
> > drwxrwxrw-  14 root     staff    .
>            ^
> > drwxr-xr-x  22 root     root     ..
> > drwx------   3 postgres postgres pg_xlog
>
> There's your problem --- postgres can't do lookups in /opt.
>
> (Surely it's not a good idea for /opt to be world writable, either?)
Oh yes. You really helped me here. Whenever uyou are in the Netherlands,
don't book a hotel, but stay with me. Free meals and all the beer you
can manage. Whisky. Whatever.

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl