pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Robert Haas <robertmhaas@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Magnus Hagander <magnus@hagander.net>
Subject: Re: pgsql: Add 'basebackup_to_shell' contrib module.
Date: Tue, 29 Mar 2022 18:34:17 -0400
Message-ID: <04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net> (raw)
In-Reply-To: <CA+TgmoYUTKqBDH7FZ99baN8yECe-CGeqgigjM=FyQYe2BXiZEg@mail.gmail.com>
References: <E1nUB2m-000CYD-DY@gemulon.postgresql.org>
	<20220315190428.2xf6klawmaq4nuyy@alap3.anarazel.de>
	<CA+TgmoZZJK7Tx1aG2yTsaOTuCdjQkB0wY9vNCTSqf7tAubtZAQ@mail.gmail.com>
	<CA+TgmoagO0Dofpy8PUyphNXaTovqRCpYOQuP+BKPeSe3kH1zJw@mail.gmail.com>
	<626827E9-4A50-493D-A8EE-EB3C238BB47F@anarazel.de>
	<CA+TgmoZ6DdRe0=YYv-dXfKCpfwaoKdUXP6gXg7qVB=3FwON1GA@mail.gmail.com>
	<CA+hUKGKbWb0ZsWKw-FzYUtcfS=FFUzL+qu6i=Kgj60HVnXEboA@mail.gmail.com>
	<CA+hUKG+-dA_4SvWvMkcJLARPOpppf6K6F3Tfgcc+wA2SAvR8Uw@mail.gmail.com>
	<CA+Tgmoat+zbzzZQJ7poXyUwiqxQxTaUid=auB4FejZ15VvDh4Q@mail.gmail.com>
	<CA+hUKGK_J2XmrhVToBfnhnAaQVP0r5C1b6ae5Kc15cSQNMgdWw@mail.gmail.com>
	<CA+hUKGK6U1PASzxGCA_c21EQ9mKbn3qyWvMB74y=X8Kjby5rtw@mail.gmail.com>
	<CA+TgmoYUTKqBDH7FZ99baN8yECe-CGeqgigjM=FyQYe2BXiZEg@mail.gmail.com>


On 3/29/22 17:19, Robert Haas wrote:
> On Tue, Mar 29, 2022 at 4:36 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>> It failed:
>>
>> https://cirrus-ci.com/task/5567070686412800
>> https://api.cirrus-ci.com/v1/artifact/task/5567070686412800/log/contrib/basebackup_to_shell/tmp_chec...
>> https://api.cirrus-ci.com/v1/artifact/task/5567070686412800/log/contrib/basebackup_to_shell/tmp_chec...
> Hmm. The log here is not very informative. It just says that the first
> time we tried to use the 'shell' target, it timed out. I suppose the
> most obvious explanation for that is that the shell command we
> executed timed out:
>
> qq{type con > "$escaped_backup_path\\\\%f"}
>
> But why should that be so? Does 'type con' not respond to EOF? I don't
> see how that can be the case. Is our implementation of pclose broken?
> If so, then I think COPY TO/FROM PROGRAM would be broken on Windows.
>

AIUI 'type con' is not the equivalent of Unix cat, especially w.r.t.
stdin. It's going to try to read from the console, not from stdin. It's
more the equivalent of 'cat /dev/tty'. So it's not at all surprising
that it hangs. I don't know of a Windows builtin that is equivalent to cat.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com






view thread (66+ messages)  latest in thread

Message-ID: <04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net>
Permalink:  ../04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net/
Also on:    postgresql.org/message-id/04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: andrew@dunslane.net, robertmhaas@gmail.com, thomas.munro@gmail.com, andres@anarazel.de, pgsql-hackers@lists.postgresql.org, magnus@hagander.net
  Subject: Re: pgsql: Add 'basebackup_to_shell' contrib module.
  In-Reply-To: <04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net>
  References: <E1nUB2m-000CYD-DY@gemulon.postgresql.org> <20220315190428.2xf6klawmaq4nuyy@alap3.anarazel.de> <CA+TgmoZZJK7Tx1aG2yTsaOTuCdjQkB0wY9vNCTSqf7tAubtZAQ@mail.gmail.com> <CA+TgmoagO0Dofpy8PUyphNXaTovqRCpYOQuP+BKPeSe3kH1zJw@mail.gmail.com> <626827E9-4A50-493D-A8EE-EB3C238BB47F@anarazel.de> <CA+TgmoZ6DdRe0=YYv-dXfKCpfwaoKdUXP6gXg7qVB=3FwON1GA@mail.gmail.com> <CA+hUKGKbWb0ZsWKw-FzYUtcfS=FFUzL+qu6i=Kgj60HVnXEboA@mail.gmail.com> <CA+hUKG+-dA_4SvWvMkcJLARPOpppf6K6F3Tfgcc+wA2SAvR8Uw@mail.gmail.com> <CA+Tgmoat+zbzzZQJ7poXyUwiqxQxTaUid=auB4FejZ15VvDh4Q@mail.gmail.com> <CA+hUKGK_J2XmrhVToBfnhnAaQVP0r5C1b6ae5Kc15cSQNMgdWw@mail.gmail.com> <CA+hUKGK6U1PASzxGCA_c21EQ9mKbn3qyWvMB74y=X8Kjby5rtw@mail.gmail.com> <CA+TgmoYUTKqBDH7FZ99baN8yECe-CGeqgigjM=FyQYe2BXiZEg@mail.gmail.com> <04e52bc8-1fa6-49c6-738e-c3b3f7b9e360@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox