MIME-Version: 1.0
References: <001901dca5a8$6fdc2760$4f947620$@pbs-software.com>
In-Reply-To: <001901dca5a8$6fdc2760$4f947620$@pbs-software.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 24 Feb 2026 14:21:39 -0500
Message-ID: <CANzqJaC6SaFTwXG=OjfSoAj3hgF55OjXPtJa5QJrHPorHNgt8w@mail.gmail.com>
Subject: Re: Using COPY via pg_background extension
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009b4a07064b96cc9e"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaC6SaFTwXG%3DOjfSoAj3hgF55OjXPtJa5QJrHPorHNgt8w%40mail.gmail.com>
Precedence: bulk

--0000000000009b4a07064b96cc9e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 24, 2026 at 11:13=E2=80=AFAM Oleg Dushin <oleg.dushin@pbs-softw=
are.com>
wrote:

> Hello everyone,
>
>
>
> I couldn't find anything on this topic in the mailing lists or in the
> documentation for the =E2=80=98pg_background=E2=80=99 extension.
>
>
>
>
> https://github.com/vibhorkum/pg_background?tab=3Dreadme-ov-file#known-lim=
itations
>
>
>
> Perhaps I overlooked something.
>
>
>
> My question is: Is it possible to use the COPY protocol in combination
> with pg_background?
>

Would "psql run from crontab" serve your purpose just as well?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000009b4a07064b96cc9e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 24, 2026 at 11:13=E2=80=AFAM =
Oleg Dushin &lt;<a href=3D"mailto:oleg.dushin@pbs-software.com">oleg.dushin=
@pbs-software.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote=
_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D=
"msg-5272244613509002611"><div lang=3D"DE" style=3D"overflow-wrap: break-wo=
rd;"><div class=3D"m_-5272244613509002611WordSection1"><p class=3D"MsoNorma=
l"><span lang=3D"EN-US">Hello everyone,<u></u><u></u></span></p><p class=3D=
"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p><p class=3D=
"MsoNormal"><span lang=3D"EN-US">I couldn&#39;t find anything on this topic=
 in the mailing lists or in the documentation for the =E2=80=98pg_backgroun=
d=E2=80=99 extension.<u></u><u></u></span></p><p class=3D"MsoNormal"><span =
lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p><p class=3D"MsoNormal"><span =
lang=3D"EN-US"><a href=3D"https://github.com/vibhorkum/pg_background?tab=3D=
readme-ov-file#known-limitations" target=3D"_blank">https://github.com/vibh=
orkum/pg_background?tab=3Dreadme-ov-file#known-limitations</a><u></u><u></u=
></span></p><p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u=
></span></p><p class=3D"MsoNormal"><span lang=3D"EN-US">Perhaps I overlooke=
d something. <u></u><u></u></span></p><p class=3D"MsoNormal"><span lang=3D"=
EN-US"><u></u>=C2=A0<u></u></span></p><p class=3D"MsoNormal"><span lang=3D"=
EN-US">My question is: Is it possible to use the COPY protocol in combinati=
on with pg_background?</span></p></div></div></div></blockquote></div><div>=
<br></div><div>Would &quot;psql run from crontab&quot; serve your=C2=A0purp=
ose just as well?</div><div><br></div><span class=3D"gmail_signature_prefix=
">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"=
>Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;=
m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></di=
v></div></div>

--0000000000009b4a07064b96cc9e--