Re: Table copy - Mailing list pgsql-general

From Andy Hartman
Subject Re: Table copy
Date
Msg-id CAEZv3crcZ+gR6enbRq6W1b_QvFvd2r7XuYXDjfhPmUT9E2hqHw@mail.gmail.com
Whole thread Raw
In response to Re: Table copy  (Andy Hartman <hartman60home@gmail.com>)
List pgsql-general
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 <hartman60home@gmail.com> 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 <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

pgsql-general by date:

Previous
From: Andy Hartman
Date:
Subject: Re: Table copy
Next
From: Adrian Klaver
Date:
Subject: Re: Table copy