On Thu, May 24, 2012 at 4:14 AM, Susanne Ebrecht
> PostgreSQL 9.0, Windows 2008
> 32 different PostGIS Databases
> round about 20 active connections by duration
> max_connections = 100
> Memory load around 30%
> CPUs load around 50%
> Network load less then 20%
> No firewall installed at all
> Randomly there is the message in log:
> could not receive data from client: Unknown winsock error 10061
> After restart - the first 10-15 minutes are ok - but then the messages start
> sometimes 3 within a minute, sometimes minutely then again all is fine for 5
> then 7 or 8 messages secondly - minutely and so on.
> less messages during night - more messages during day - but usually during
> there is very rare traffic.
> It isn't a connection from a special tool to a special database creating the
> The failing connections are to different databases and from different users.
> It can be
> a pgAdmin connection or a connection from an application. It is totally
> Max connections isn't reached at all - neither network nor CPU nor RAM are
> What else could create that issue?
> How can I solve the issue?
In the server log, what are the messages preceding the 10061 message?
In response to
pgsql-novice by date
|Next:||From: Luiz K. Matsumura||Date: 2012-05-25 20:48:14|
|Subject: Re: return values(table) from stored function from MS visual
|Previous:||From: Merlin Moncure||Date: 2012-05-25 18:32:26|
|Subject: Re: return values(table) from stored function from MS visual foxpro|