public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Andy Hartman <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Table copy
Date: Wed, 5 Feb 2025 16:25:10 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com>
References: <CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com>
<[email protected]>
<CAEZv3cpop1fqe7Z8tsiAvbvzSFVqZUMwLJ7ccv0g0F8hKhD_GA@mail.gmail.com>
<[email protected]>
<CAEZv3cqCAZhh9UVV8EvwW7W53HT84TnvyCTgzXNbOp42zE7-ug@mail.gmail.com>
<[email protected]>
<CAEZv3cru5+haHbmD+Erga_QPp6x5E8-s1NLZ0MV4vihk51=15A@mail.gmail.com>
<CAEZv3co2Nmkn462mUL9WXUxwpYws62SD_YDn9xbpUkEZLB-jJA@mail.gmail.com>
<[email protected]>
<CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com>
On 2/5/25 14:58, Andy Hartman wrote:
> 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
Slick, except for the part where it is not working.
I have no idea what is going on at this point.
Some questions:
1) I don't know where the below is coming from?:
2025-02-04 14:42:18.265 EST [4796] LOG: could not send data to client:
An established connection was aborted by the software in your host machine.
I have searched the Postgres and SimpleSql source and I cannot find it
in either.
Is the error message straight from the log or was it translated?
Where did you install Postgres from?
2) What are the exact versions for SimpleSql and the MS SQL Server and
Postgres drivers you are using?
3) What is the network setup between the source and destination databases?
4) What if you move an overall smaller quantity of data over?
>
> On Wed, Feb 5, 2025 at 4:23 PM Adrian Klaver <[email protected]
> <mailto:[email protected]>> 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 that
> > 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
> [email protected] <mailto:[email protected]>
>
--
Adrian Klaver
[email protected]
view thread (4+ messages)
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 using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Table copy
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox