Re: pg_terminate_backend idea - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_terminate_backend idea
Date
Msg-id 22087.1119475409@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_terminate_backend idea  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: pg_terminate_backend idea
List pgsql-hackers
"Magnus Hagander" <mha@sollentuna.net> writes:
> Assuming we don't get such a case, and a chance to fix it, before 8.1
> (while still hoping we will get it fixed properly, we can't be sure, can
> we? If we were, it'd be fixed already). In this case, will you consider
> such a kludgy solution as a temporary fix to resolve a problem that a
> lot of users are having? And then plan to have it removed once sending
> SIGTERM directly to a backend can be considered safe?

Kluges tend to become institutionalized, so my reaction is "no".  It's
also worth pointing out that with so little understanding of the problem
Rod is reporting, it's tough to make a convincing case that this kluge
will avoid it.  SIGTERM exit *shouldn't* be leaving any corrupted
locktable entries behind; it's not that much different from the normal
case.  Until we find out what's going on, introducing still another exit
path isn't really going to make me feel more comfortable, no matter how
close it's alleged to be to the normal path.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Chris Campbell
Date:
Subject: Re: Problem with dblink regression test
Next
From: Marko Kreen
Date:
Subject: [PATCH] pgcrypto: pgp_encrypt