Mischa Sandberg <mischa_sandberg@telus.net> writes:
> If anyone is interested in creating hung backends, you can
> create a named pipe, and tell the server to COPY from it.
That won't create a problematic situation though, until/unless you
SIGQUIT the parent postmaster.
Personally I think of this as "what happens after someone
kill -9's a postmaster that has live children".
regards, tom lane