Alvaro Herrera <[EMAIL PROTECTED]> writes: > Joshua D. Drake wrote: >> 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. It sounds to me like we don't actually know that, because the client doesn't know how to restart the postmaster without rebooting the OS. (Josh says "pg_ctl stop" doesn't work in this state, which is a tad interesting in itself, because that doesn't go through a connection request.) It would be useful to try killing off the postgres processes via task manager and then see if a new postmaster can be started and if things then behave normally, or if a reboot is truly needed. The bottom line here is that all we have so far are client-side observations ("I get this message") and we have no clue what state the postmaster thinks it's in. We really need more information. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org