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