Re: Moving pg_xlog problem - Mailing list pgsql-admin

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?)

            regards, tom lane