"Sofer, Yuval" <Yuval_Sofer@xxxxxxx> wrote: > Postgres server crashed on windows vista. What causes you to say that the server crashed? > 2010-04-07 07:00:35.694 LOG: could not receive data from client: > Unknown winsock error 10061 > 2010-04-07 07:00:35.694 LOG: could not receive data from client: > Unknown winsock error 10061 > 2010-04-07 07:00:35.694 LOG: unexpected EOF on client connection > 2010-04-07 07:00:35.694 LOG: unexpected EOF on client connection This looks like a network disruption or a client machine being turned off. Sort of. The odd thing is the error code of 10061, which is supposed to be for "connection refused" -- are you using anything which might be trying to connect out from the PostgreSQL server (e.g., dblink)? > 2010-04-07 08:27:53.934 LOG: received fast shutdown request > 2010-04-07 08:27:53.934 LOG: aborting any active transactions This looks like the server was shut down an hour and half after the broken client connections. Did you shut it down at 8:27? > Why did the postgres server crashed? What did you see that makes you think it did? > Is it operating system problem or postgres? I don't see any indication of a PostgreSQL problem. By the way, what version of PostgreSQL is this? > Is there any work around ? Without knowing what happened, it's hard to say. Any idea what might have happened with the network or client machine(s) at 7:00? If you review this page and follow the suggestions there, you'll give us more to work with when trying to help: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
