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.