Limit on connections - Mailing list pgsql-cygwin

From Colin Mangiagalli
Subject Limit on connections
Date
Msg-id 002101c2dc0c$3a2ad8c0$7201a8c0@camara.co.za
Whole thread Raw
Responses Re: Limit on connections  (Jason Tishler <jason@tishler.net>)
List pgsql-cygwin
Hi
 
Is there a limit under postgresql/cygwin/windows to the maximum number of connections you can make to the database.
 
I am using PostgreSQL 7.2.1-2 and Poolman 2.1-b1 to managed the connections
 
I had this weird problem that there were about 35 connections open (looking at the windows task manager), all doing
something (what I don't know) and the CPU usage was sitting at 100%
 
I have seen this problem twice before, but don't know how to replicate it. Also, I have to actaully restart the machine in
order to close these connections, because the postmaster service won't shut down.
What does that mean if the connections don't want to close normally?
 
Is there a way to see what could have opened the connections?
 
Thanks
Colin

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: PSQL 7.2.1 under cygwin
Next
From: Nyo Maw
Date:
Subject: posgresql on Windows XP