Skip site navigation (1) Skip section navigation (2)

Re: Postgres 8.4.2 "could not receive data from client: Unknown winsock error 10061"

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <skhan(at)esri(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres 8.4.2 "could not receive data from client: Unknown winsock error 10061"
Date: 2010-12-18 21:17:22
Message-ID: 4D0CD08202000025000387B1@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Syed Khan  wrote:
 
> I have setup a warm stanby solution using Postgres 8.4.2 on windows
> 2008 64 bit server every few hours the primary "live" database goes
> down with the following messages. Is there a fix to the issue ?
> Please tell me what could be happening...?
> 
> I know the servers are up
> 
> 
> PSTLOG: could not receive data from client: Unknown winsock error
> 10061
> PSTLOG: unexpected EOF on client connection
> PSTLOG: could not receive data from client: Unknown winsock error
> 10061
> PSTLOG: unexpected EOF on client connection
> PSTLOG: received fast shutdown request
> PSTLOG: aborting any active transactions
> PSTFATAL: terminating connection due to administrator command
> PSTFATAL: terminating connection due to administrator command
> PSTLOG: autovacuum launcher shutting down
> PSTLOG: shutting down
> PSTLOG: database system is shut down
 
I've never seen such behavior.  Do you have any antivirus software
installed on the server?  (Even when you "stop" or "close" it, such
software often causes problems unless it is uninstalled.)  Is
anything else unusual happening at that point in time, or showing in
the logs?
 
-Kevin

pgsql-admin by date

Next:From: Benoit Clennett-SiroisDate: 2010-12-20 13:41:53
Subject: Postgres crash during low-traffic period, need advice.
Previous:From: Tsing, VadimDate: 2010-12-18 20:09:17
Subject: Re: Copying database directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group