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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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