Re: Database server restartig

Shoaib-

The "unexpected EOF on client connection" messages probably aren't cause for
great concern, as they could be caused by any event that results in a
connection getting lost, such as a telnet session getting lost.

The "database system was interrupted" message is likely the important one in
this case and indicates that the database has been started up but is not
finding the everything tidied up as it should be if a graceful shutdown has
been done. Does the time match your daily reboot? Perhaps you aren't calling
pg_ctl -stop before doing the reboot.

BTW, unless you've got something else running on the system that requires it
and if this is a Linux system, the reboot probably isn't necessary for
either the OS or postgreSQL.

-Nick


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of shoaib
Sent: Sunday, May 04, 2003 9:57 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Database server restartig


Hello Everybody,

We are using postgressql 7.2.2 . our system running is 24 hours day it a
preventive reboot once a day.some time I am getting this error and after it
the sytem hang .Can any body help in this.

DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  pq_recvbuf: unexpected EOF on client connection
DEBUG:  database system was interrupted at 2003-05-03 04:17:19 SGT
DEBUG:  checkpoint record is at 3/85EA18B0
DEBUG:  redo record is at 3/85EA18B0; undo record is at 0/0; shutdown FALSE
DEBUG:  next transaction id: 4111285; next oid: 7557242
DEBUG:  database system was not properly shut down; automatic recovery in
progress
DEBUG:  ReadRecord: record with zero length at 3/85EA18F0
DEBUG:  redo is not required
DEBUG:  recycled transaction log file 0000000300000083
DEBUG:  recycled transaction log file 0000000300000084
DEBUG:  database system is ready
DEBUG:  pq_recvbuf: unexpected EOF on client connection


Regards

Shoaib