public inbox for [email protected]help / color / mirror / Atom feed
Re: Table copy 4+ messages / 2 participants [nested] [flat]
* Re: Table copy @ 2025-02-05 21:23 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Adrian Klaver @ 2025-02-05 21:23 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> 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] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table copy @ 2025-02-05 22:58 Andy Hartman <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Andy Hartman @ 2025-02-05 22:58 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> 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 PM Adrian Klaver <[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] > > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table copy @ 2025-02-05 22:59 Andy Hartman <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Andy Hartman @ 2025-02-05 22:59 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> This is going to be a monthly process not just a 1 time exercise. On Wed, Feb 5, 2025 at 5:58 PM Andy Hartman <[email protected]> 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 > > On Wed, Feb 5, 2025 at 4:23 PM Adrian Klaver <[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] >> >> ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table copy @ 2025-02-06 00:25 Adrian Klaver <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2025-02-06 00:25 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> 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] ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-02-06 00:25 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-02-05 21:23 Re: Table copy Adrian Klaver <[email protected]> 2025-02-05 22:58 ` Andy Hartman <[email protected]> 2025-02-05 22:59 ` Andy Hartman <[email protected]> 2025-02-06 00:25 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox