Re: [HACKERS] Can postgresql accept mutliple connections in the same

[Dru]

Neil Conway wrote:
On Fri, 2004-11-19 at 17:15 +1300, Dru wrote:
 

Ok rules out that possibility also.  Is there any stress testing 
software for postgresql to find out how and when it breaks?
   

Try contrib/pgbench.
 

The website uses php,
the problem could be in the wrapper code for PHP though. I havnt
got much luck asking php developers about the problem though.
   

pgbench uses libpq (i.e. the native C client interface to PostgreSQL) --
if you encounter connection failures using it, that will narrow down the
set of possible culprits. Since you don't get an error message in the
PostgreSQL logs when a connection is refused, it seems that the
connection attempt doesn't even make it as far as the postmaster, so I
would be skeptical of the software between the client and the backend
(e.g. PHP, perhaps some kernel/TCP weirdness, etc.).
-Neil
 

I'll have a  look around for kernel limits regarding socket opening etc.
It could be that  thats causing the problems. 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]