Re: Reg: unexpected EOF on client connection

Dear All,

Since you have postgres database server. You may need to check at client desktop PCs which is connected to Postgres database.
Especially the physical ethernet connection from clients Desktop PCs to ethernet connection. (if its works within company local area network)
You have option:

1) ping remote client Desktop PCs (which is, you suspect the Desktop PCs down).
2) check physical ethernet connection of the Desktop PC.
3) ping localhost to check if the network interface connection is working.  

Regards,

MOHAMMAD ADLI BIN MT TAJUDIN
A8-2-7, DESA PANDAN APARTMENTS,
OFF JALAN KG. PANDAN,
55100 KUALA LUMPUR,
WEST MALAYSIA.

H/p number:  (017) 362 3661
Email: white(dot)heron(at)yahoo(dot)com

________________________________
From: Ian Lea <ian(dot)lea(at)gmail(dot)com>
To: Hariraman Jayaraj <hariraman(dot)ocp(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Sent: Wednesday, November 23, 2011 5:42 PM
Subject: Re: [ADMIN] Reg: unexpected EOF on client connection

> I am new to Postgres Administration. I am getting this below mentioned error
> in my pg_log and server looks in hanged state whenever this error is getting
> logged.
> OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server
> - Jboss.
>
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection

These generally mean that the client has gone away without closing
database connections.  You should check your client code.

It is highly unlikely these errors would cause your server to hang.

--
Ian.