Re: Error 10061

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ivan Garro <ivangarro(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error 10061
Date: 2008-07-30 19:32:32
Message-ID: 20080730193232.GF3977@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Garro escribió:
> Hola Gente, les comento lo que me pasa, mi base de datos (8.2) esta montada
> sobre un windows XP y funciona religiosamente bien,
> pero de repente se rompe y no funciona mas, puede estar andando
> dos o tres meses los mas bien. El problema lo soluciono
> con corriendo un pg_resetxlog......
>
> el log es el siguiente:
>
> LOG: database system was shut down at 2008-07-30 10:21:08 Hora est. de Sudamérica E.
> LOG: checkpoint record is at 0/110000C0
> LOG: redo record is at 0/110000C0; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 0/725046; next OID: 17508
> LOG: next MultiXactId: 1; next MultiXactOffset: 0
> LOG: database system is ready
> LOG: could not receive data from client: Unknown winsock error 10061
> LOG: unexpected EOF on client connection

Huh, this is really weird. 10061 is CONNREFUSED according to
http://msdn.microsoft.com/en-us/library/ms740668.aspx

Exactly what 8.2.x version are you running?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ismael .... 2008-07-30 19:54:53 Alternative way to access a field in a %ROWTYPE variable
Previous Message Francisco Reyes 2008-07-30 19:03:25 Re: Error 10061