| From: | Andy Hartman <hartman60home(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Table copy |
| Date: | 2025-02-05 22:59:10 |
| Message-ID: | CAEZv3crcZ+gR6enbRq6W1b_QvFvd2r7XuYXDjfhPmUT9E2hqHw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>>
>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-02-06 00:25:10 | Re: Table copy |
| Previous Message | Andy Hartman | 2025-02-05 22:58:06 | Re: Table copy |