Re: Moving pg_xlog problem

On Tue, 8 Nov 2005, Joost Kraaijeveld wrote:

> Panoramix:/var/lib/postgresql/8.0/main# ls /opt/pg_xlog/ -al
> total 295284
> drwx------   3 postgres postgres .
> drwxrwxrw-  14 root     staff    ..
> -rw-------   1 postgres postgres 0000000100000033000000B4
> -rw-------   1 postgres postgres 0000000100000033000000B5
> drw-------   2 postgres postgres archive_status

Here's another problem besides the one Tom pointed out..why is your
archive_status directory missing the execute bit?

I noticed you ran all the ls commands as root, probably best to run them as
postgres when trying to track down a problem of this nature.


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954