Re: Win32 hard crash problem

Joshua D. Drake wrote:
> Alvaro Herrera wrote:
> >Joshua D. Drake wrote:
> >>Tom Lane wrote:
> >>>Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> >>>>On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote:
> >>>>>Yes they are using a connection pool. A java based one.
> >>>>Since java has it's own protocol implementation, this is totally
> >>>>unrelated to any libpq error messages.
> >>>Another important point that we've not been given information on:
> >>>when pgAdmin/libpq starts failing like this, exactly what is happening
> >>>with the connection pool? Is it still able to issue queries, and
> >>>if not what happens exactly?
> >>No, when this happens everything stops. The only thing they get back is
> >>that message until they reboot the server. The web app (via
> >>java/connection pool), pgAdmin both give the same error.
> >
> >Actually Dave Cramer told me that if the postmaster was stopped and then
> >restarted, it would start answering fine again. Which would make a lot
> >of sense.
>
> I already said that ;). The problem IS NOT that we can't restart the
> system and get postgresql back. It is that it happens at all.

It is quite different a bug that can only be fixed by "rebooting the
server" (which to me means taking the operating system down and starting
it afresh) than one that can be fixed by restarting the PostgreSQL
server (_without_ taking the operating system down). I've been reading
"reboot" all along -- sorry if I missed an email saying otherwise.

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