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

2004-11-22 Thread Dru
Zeugswetter Andreas DAZ SD wrote: I am running of postgresql database servers with generally 30-50 users at a time per server. I have noticed one thing for web based databases that they fail to initialse a pg_connection connection every now and again and return no error message at all.

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

2004-11-22 Thread 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 thoug

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

2004-11-19 Thread Zeugswetter Andreas DAZ SD
>> I am running of postgresql database servers with generally 30-50 users >> at a time per server. I have noticed one thing for web based databases >> that they fail to initialse a pg_connection connection every now and >> again and return no error message at all. I am thinking of the PG_SOM

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

2004-11-18 Thread Michael Fuhr
On Fri, Nov 19, 2004 at 05:15:54PM +1300, Dru wrote: > I'll get the developer to write down the exact error when it happens again. It would be better to cut and paste the error message instead of writing it down. What people think they see doesn't always match what's on the screen. -- Michael

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

2004-11-18 Thread Joshua D. Drake
I've spent ages going though logs and turning debugging to max. There is no error message returned at all. The connection handle is returned as NULL. This is in the php functions though so their pg_last_error() function may not be catching all error messages but it seems it should pass on ever

Re: [HACKERS] Can postgresql accept mutliple connections in

2004-11-18 Thread Neil Conway
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 muc

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

2004-11-18 Thread Dru
Tom Lane wrote: Dru <[EMAIL PROTECTED]> writes: I am running of postgresql database servers with generally 30-50 users at a time per server. I have noticed one thing for web based databases that they fail to initialse a pg_connection connection every now and again and return no error messag

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

2004-11-18 Thread Dru
Neil Conway wrote: On Fri, 2004-11-19 at 16:17 +1300, Dru wrote: Though one of hte developers tells me that sometimes it gets a link resource allocation error on opening connections to the database server which i dont know if that is related. I'm not sure what you mean by a "link resour

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

2004-11-18 Thread Tom Lane
Dru <[EMAIL PROTECTED]> writes: > I am running of postgresql database servers with generally 30-50 users > at a time per server. I have noticed one thing for web based databases > that they fail to initialse a pg_connection connection every now and > again and return no error message at all.

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

2004-11-18 Thread Neil Conway
On Fri, 2004-11-19 at 16:17 +1300, Dru wrote: > Though one of hte developers > tells me that sometimes it gets a link resource allocation error on > opening connections to the database server which i dont know if that is > related. I'm not sure what you mean by a "link resource allocation erro

[HACKERS] Can postgresql accept mutliple connections in the same instance?

2004-11-18 Thread Dru
I am running of postgresql database servers with generally 30-50 users at a time per server. I have noticed one thing for web based databases that they fail to initialse a pg_connection connection every now and again and return no error message at all. Though one of hte developers tells me th