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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954