Feedback-ID: i76984098:Fastmail
Message-ID: <f08ebe24-cb76-4a61-8226-2a02daa8a391@aklaver.com>
Date: Wed, 5 Feb 2025 16:25:10 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Table copy
To: Andy Hartman <hartman60home@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
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>
 <CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3cpo8EE3KVG=K07z44T-97+7rcxzOkhsCYdHfV7VwdhgzA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/f08ebe24-cb76-4a61-8226-2a02daa8a391%40aklaver.com>
Precedence: bulk

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 <adrian.klaver@aklaver.com 
> <mailto: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 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
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com