[ADMIN] postgres crashes

[Barry]

Hi All   After running for a couple of days, my postgres server crashes. When I do a /etc/init.d/postgresql status, I get unused. And when I then try and start it, it fails. Only a reboot helps. Here's my /var/log/postgres :   DEBUG:  database system is ready ERROR:  Relation "cleared" does not exist DEBUG:  pq_recvbuf: unexpected EOF on client connection Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1658) running in "/var/lib/pgsql/data"? Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1658) running in "/var/lib/pgsql/data"? Lock file "/tmp/.s.PGSQL.5432.lock" already exists. Is another postmaster (pid 1658) using "/tmp/.s.PGSQL.5432"? /usr/bin/postmaster: cannot create UNIX stream port DEBUG:  database system was interrupted at 2004-02-16 16:35:09 CET DEBUG:  checkpoint record is at 0/28549D8 DEBUG:  redo record is at 0/28549D8; undo record is at 0/0; shutdown FALSE DEBUG:  next transaction id: 54058; next oid: 74008 DEBUG:  database system was not properly shut down; automatic recovery in progress DEBUG:  ReadRecord: record with zero length at 0/2854A18 DEBUG:  redo is not required DEBUG:  database system is ready Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? DEBUG:  database system was interrupted at 2004-02-25 13:16:13 CET DEBUG:  checkpoint record is at 0/2854A18 DEBUG:  redo record is at 0/2854A18; undo record is at 0/0; shutdown TRUE DEBUG:  next transaction id: 54058; next oid: 74008 DEBUG:  database system was not properly shut down; automatic recovery in progress DEBUG:  ReadRecord: record with zero length at 0/2854A58 DEBUG:  redo is not required DEBUG:  database system is ready Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? Lock file "/var/lib/pgsql/data/postmaster.pid" already exists. Is another postmaster (pid 1647) running in "/var/lib/pgsql/data"? DEBUG:  database system was interrupted at 2004-02-25 16:29:54 CET DEBUG:  checkpoint record is at 0/2854A58 DEBUG:  redo record is at 0/2854A58; undo record is at 0/0; shutdown TRUE DEBUG:  next transaction id: 54058; next oid: 74008 DEBUG:  database system was not properly shut down; automatic recovery in progress DEBUG:  ReadRecord: record with zero length at 0/2854A98 DEBUG:  redo is not required DEBUG:  database system is ready Any pointers would be much appreciated.   Thanks Barry