MIME-Version: 1.0
References: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
 <fd275e8a-80fa-4915-8aa3-9b48728d562a@aklaver.com> <CAEZv3cpop1fqe7Z8tsiAvbvzSFVqZUMwLJ7ccv0g0F8hKhD_GA@mail.gmail.com>
 <0057c073-6dcb-4425-92fc-3a766a78ee96@aklaver.com> <CAEZv3cqCAZhh9UVV8EvwW7W53HT84TnvyCTgzXNbOp42zE7-ug@mail.gmail.com>
 <ae581d81-3d0a-471b-9dc5-e23d98ee1fe6@aklaver.com> <CAEZv3cru5+haHbmD+Erga_QPp6x5E8-s1NLZ0MV4vihk51=15A@mail.gmail.com>
 <CAEZv3co2Nmkn462mUL9WXUxwpYws62SD_YDn9xbpUkEZLB-jJA@mail.gmail.com> <bb0c2d50-1b68-4ee6-bf5d-b03e420fad26@aklaver.com>
In-Reply-To: <bb0c2d50-1b68-4ee6-bf5d-b03e420fad26@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Wed, 5 Feb 2025 17:58:06 -0500
Message-ID: <CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com>
Subject: Re: Table copy
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a0b3ec062d6d0fe9"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cpo8EE3KVG%3DK07z44T-97%2B7rcxzOkhsCYdHfV7VwdhgzA%40mail.gmail.com>
Precedence: bulk

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

Reduce batch size still caused error as reported nothing in WIndows Server
log...

 The SimplySql is slick because just qry from src and load to dst ... Is
there any way to somehow show more of the error in PS i tried the $error
but nothing very descriptive

On Wed, Feb 5, 2025 at 4:23=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

> On 2/5/25 13:09, Andy Hartman wrote:
> > I also reduced batch size to 5000 on the last run  .. I like using this
> > SImplySql because it's a script I can launch, so that's why I chose tha=
t
> > solution...  I'm using it to load a History Env.
>
> You really need to complete your thoughts, remember we have no idea what
> you are seeing unless you tell us.
>
> Reducing the batch size did what?
>
>
> >
> > THanks again.
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div dir=3D"ltr">Reduce batch size still caused error as reported nothing i=
n WIndows Server log...<br><br>=C2=A0The SimplySql is slick because just qr=
y from src and load to dst ... Is there any way to somehow show more of the=
 error in PS i tried the $error but nothing very descriptive=C2=A0</div><br=
><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D=
"gmail_attr">On Wed, Feb 5, 2025 at 4:23=E2=80=AFPM Adrian Klaver &lt;<a hr=
ef=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 2/5/25 =
13:09, Andy Hartman wrote:<br>
&gt; I also reduced batch size to 5000 on the last run=C2=A0 .. I like usin=
g this <br>
&gt; SImplySql because=C2=A0it&#39;s a script I can launch, so that&#39;s w=
hy I chose that <br>
&gt; solution...=C2=A0 I&#39;m using it to load a History Env.<br>
<br>
You really need to complete your thoughts, remember we have no idea what <b=
r>
you are seeing unless you tell us.<br>
<br>
Reducing the batch size did what?<br>
<br>
<br>
&gt; <br>
&gt; THanks again.<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000a0b3ec062d6d0fe9--