Noah Misch <noah@leadboat.com> writes:
> On Mon, Apr 15, 2019 at 08:08:48PM -0400, Tom Lane wrote:
>> I interpret this as "the single-user backend exited before we could stuff
>> 'SELECT 1 + 1' down the pipe to it, and the Perl script is not expecting
>> to get a write failure there".
> Perhaps I should write the 'SELECT 1 + 1' to a regular file and redirect input
> from that file.
Yeah, that was the first idea that occurred to me as well.
Kinda grotty, but ...
Another idea is to shove the problem off on a sub-shell, that is run
echo SELECT 1 + 1 | postgres --single ...
regards, tom lane