> > "Medora Schauer" <[EMAIL PROTECTED]> writes: > > I looked in the log again and sure enough I missed this immediately > > before the WARNINGS: > > > PANIC: link from /data/database/pg_xlog/00000001000000D9 to > > /data/database/pg_xlog/00000001000000E1 (initialization of log file 1, > > segment 225) failed: No such file or directory > > > Looks like a file system problem right? > > Definitely seems like a can't-happen case. What file system are you > running Postgres on?
I found this in /var/log/messages: Dec 1 09:23:40 Qc kernel: __alloc_pages: 0-order allocation failed (gfp=0x1d2/0) Dec 1 09:23:40 Qc kernel: VM: killing process postmaster Is this because we are running out of memory? Our file system is ext3. Medora ---------------------------(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