Re: [PATCH] Prevent hanging on unreachable hosts on startup - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [PATCH] Prevent hanging on unreachable hosts on startup
Date
Msg-id 3741.1325731017@sss.pgh.pa.us
Whole thread Raw
In response to [PATCH] Prevent hanging on unreachable hosts on startup  ("Ryan P. Kelly" <rpkelly22@gmail.com>)
Responses Re: [PATCH] Prevent hanging on unreachable hosts on startup  (Ryan Kelly <rpkelly22@gmail.com>)
List pgsql-bugs
"Ryan P. Kelly" <rpkelly22@gmail.com> writes:
> The signal handler installed by setup_cancel_handler() will ignore
> attempts to exit psql should a host be unreachable.

Hm.  That may be worth doing something about, but the proposed patch
seems more like a quick-and-dirty hack than a solution.  The main
thing I don't like about it is that if we care about this scenario
during initial startup, we should also care about it during a \c
command, but just delaying the installation of the signal handler
won't fix that case.

More generally, what if the server becomes unreachable mid-session?
I'm not sure how much there is to be done about that case, since
there's probably no good way to distinguish it from a query that
takes a really long time.  But if we're going to think about this,
we might as well think about all the cases.

            regards, tom lane

pgsql-bugs by date:

Previous
From: dean.w.schulze@gmail.com
Date:
Subject: BUG #6380: dropdb gives error while loading shared libraries: liblber-2.3.so.0
Next
From: Michael Beattie
Date:
Subject: Re: BUG #6380: dropdb gives error while loading shared libraries: liblber-2.3.so.0