DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=sKNf8sUBvPU/ysuAsL04ycwh7VgmLfbsWeeS1+Tz27g0Q3778QHpDDET8hS1K44PEEvqRsqLqb3a2thKpj1D+kbd3IMZ+E/F+yoehDp8hAi0MT3qhcBKN2C/OC3awspMGOilGLw0EzwzshXoc+h0yvyEThUQavd1/lhhgyBDs0s=;
Date: Thu, 24 May 2007 05:46:58 -0700 (PDT)
From: jing han <jing_han_66@yahoo.com>
Subject: unexpected EOF on client connection
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ascii
Message-ID: <496870.61854.qm@web53503.mail.re2.yahoo.com>

Hello,

We move from postgresql 7.3.2 to 8.1.8. I meet some problems with postgresql 8.1.8.

We are using the same code as what we used on postgresql 7.3.2,  but we didn't meet the same problem with 7.3.2. (Our code is in C/C++ using postgresql c interface, OS is fedora core 6)

We have some processes keep querying database all the time, I found that when I issue "killall postmaster", I get the following log messages in linux console:

LOG: unexpected EOF on client connection (for 8.1.8)

but I didn't get the above log message with 7.3.2.

Another problem is: my processes crashes sometimes because of "unexpected EOF on client connection", but this never happen to my processes when they were running on 7.3.2.

One more problem is: sometimes after I killall postmaster, I restart postmaster, I got "connection to database 'dbname' failed" (not always), but I never get into this situation when I use postgres 7.3.2

Can you tell me what I could to do to fix my problem?


By the way, I found that postgresql 8.1.8 always log messages to console not to a file, but 7.3.2 log its messages to /var/log/messages file.

Thank you in advance.


Best regards 
jing


____________________________________________________________________________________Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz