"Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com> 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