Re: Followup comment for bug report 'postmaster ignores SIGPIPE' [was: Bug#255208: Would help with client aborts, too.] - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Followup comment for bug report 'postmaster ignores SIGPIPE' [was: Bug#255208: Would help with client aborts, too.]
Date
Msg-id 29170.1143423286@sss.pgh.pa.us
Whole thread Raw
In response to Re: Followup comment for bug report 'postmaster ignores SIGPIPE' [was: Bug#255208: Would help with client aborts, too.]  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Followup comment for bug report 'postmaster ignores SIGPIPE' [was: Bug#255208: Would help with client aborts, too.]
List pgsql-bugs
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> Allowing SIGPIPE to kill the backend is completely infeasible, as the
>> backend would be unable to release locks etc before dying.

> So the upshot is really not that ignoring SIGPIPE is specifically
> intended as the optimal solution but that writing a proper cleanup
> handler for SIGPIPE seems very difficult.

Well, if we did want to change this it would be far easier and safer to
do the other thing (ie, set QueryCancel upon noticing a write failure).

The question is whether doing either one is really a material
improvement, seeing that neither is going to provoke an abort
until/unless the backend actually tries to write something to the client.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Martin Pitt
Date:
Subject: Fwd: Bug#358546: failure of pg_ctl start -w -D
Next
From: "Jim C. Nasby"
Date:
Subject: Re: BUG #2358: Vacuum & \dt problems