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.
____________________________________________________________________________________Got a little couch potato?
Check out fun summer activities for kids.
pgsql-interfaces by date
|Next:||From: jing han||Date: 2007-05-24 15:28:06|
|Subject: transactionID wraparound problem|
|Previous:||From: Andrew McNamara||Date: 2007-05-23 23:12:28|
|Subject: Re: How do you convert PostgreSQL internal binary field to C datatypes |