Re: Moving pg_xlog problem

On Tue, 2005-11-08 at 13:29 -0500, Tom Lane wrote:
> Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl