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@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
