public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andy Hartman <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Table copy
Date: Wed, 5 Feb 2025 17:59:10 -0500
Message-ID: <CAEZv3crcZ+gR6enbRq6W1b_QvFvd2r7XuYXDjfhPmUT9E2hqHw@mail.gmail.com> (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>
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]
>>
>>
view thread (4+ messages) latest in thread
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: <CAEZv3crcZ+gR6enbRq6W1b_QvFvd2r7XuYXDjfhPmUT9E2hqHw@mail.gmail.com>
* 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