Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfoMf-005Hm1-96 for pgsql-general@arkaria.postgresql.org; Wed, 05 Feb 2025 22:59:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tfoMe-002AHj-AZ for pgsql-general@arkaria.postgresql.org; Wed, 05 Feb 2025 22:59:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfoMd-002AHa-WF for pgsql-general@lists.postgresql.org; Wed, 05 Feb 2025 22:59:24 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tfoMb-003Ofh-38 for pgsql-general@lists.postgresql.org; Wed, 05 Feb 2025 22:59:23 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-6f9625c0fccso3700607b3.1 for ; Wed, 05 Feb 2025 14:59:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738796362; x=1739401162; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Z8mMNeMTKLs7/8JBDv/Vli09RV5Y8rMM2Ko0r6/mVVM=; b=FidyxsJ48jXKuPcbzVbzUxNa1XNL6fAn2WV1pGlz3EBS6aZ4xMJmQRLftvNgB5o6ew DwiEGM4P9qyfXSCzmGR6z77OqUuhgMXv7g351xqmcCacnle2sKZfkZrcNFbipM5Lp9Jh V7LGyC0aNZpWc2tJTtJxJaheTdIh7FcQ29jwswEnQmoq9RcAuKsNp6ZQrbWETLjtZ1v3 3ZhuDC0XmF67Y5tkcB4UxFPNYHibFHbbcO3+GeYta1rOwM9kk9x8OeTrf0vJzV5bpx4V lvI9EnD+Lkfm8U3jTRmygsx8PfKdONZwGZh5fuNA2IKILa28lVElj9+imqGEmoHLPZLe fjZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738796362; x=1739401162; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Z8mMNeMTKLs7/8JBDv/Vli09RV5Y8rMM2Ko0r6/mVVM=; b=na6IAIDaV4Ip3+EdKj5tUCnx0Qyur/OoP8eyG59KwxwaSDECol47r+/b4kPBwcHrK8 a5H8uC050Yx9cyB48YlIrkz3Hh3Xlw5yQTP5PMfgC5z+u5fuKGMM/T8KGMTtieVpXvcT 2hkePH2LSo7ElAH2r/gtQVxJpdsYAbzROxhPAtyGwPaqrHe9o00kNrlLElll+6SNYF2E BJVlc/FHWfQRKZW0q2fxZlDcQ8wvpGSCHjYFPIdk97GngQr35vByo8rVQuXBEOYEI2A8 1p3PvTbLE3L4LzVkb8isu4Kk1K3dm5A9inyNjWWj25l9j0VmsUgwkWyOohJytvUpjO+9 KMMA== X-Gm-Message-State: AOJu0YyySHGkLFfw4t43T36HlEhZH0jy7H4z3t10JTPMln5v0O52REM8 QljG5F9uKb2zV01ZNCUXrPfXnCO/63PM+tex3VSbuWFuaJjCDBwfIvG5fgz8j+FMgcky2eKRvcY tQw2lZ5hMectnfFZ0boPgq9g/UacyjQ== X-Gm-Gg: ASbGnctlunLVMi067SUdspvxWl9Brs6ppHGXhJefcrLWpXdSKT+57SpEiPpfzVPlXVj cob7vVoFkHCRvs5k6HdbPJLylvF0TOWqSmPpFevzoOO8IrldUz0ely4fGPUmKXclvQV2aQx0= X-Google-Smtp-Source: AGHT+IEIkNCOaCl7sLywhoqJ2W5hANuPQjnbmDrGwRrrsNoXchLazmTu5ueQJS4HrLJUY0vVcVGSCQCLckXK3RGkSIs= X-Received: by 2002:a05:690c:4c01:b0:6f9:4413:3db8 with SMTP id 00721157ae682-6f989be65admr40144687b3.0.1738796361719; Wed, 05 Feb 2025 14:59:21 -0800 (PST) MIME-Version: 1.0 References: <0057c073-6dcb-4425-92fc-3a766a78ee96@aklaver.com> In-Reply-To: From: Andy Hartman Date: Wed, 5 Feb 2025 17:59:10 -0500 X-Gm-Features: AWEUYZkwM2CR0dRTaza-ARIhVQbOhNotCNscPeEEMWmyf55A79o6XqeF0AgTaeQ Message-ID: Subject: Re: Table copy To: Adrian Klaver Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000007a2864062d6d139e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007a2864062d6d139e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is going to be a monthly process not just a 1 time exercise. On Wed, Feb 5, 2025 at 5:58=E2=80=AFPM Andy Hartman wrote: > Reduce batch size still caused error as reported nothing in WIndows Serve= r > 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=E2=80=AFPM Adrian Klaver > wrote: > >> On 2/5/25 13:09, Andy Hartman wrote: >> > I also reduced batch size to 5000 on the last run .. I like using thi= s >> > 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 >> >> --0000000000007a2864062d6d139e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This is going to be a monthly process not just a 1 time ex= ercise.

On Wed, Feb 5, 2025 at 5:58=E2=80=AFPM Andy H= artman <hartman60home@gmail.c= om> wrote:
Reduce batch size still caused error as reported nothing= in WIndows Server log...

=C2=A0The SimplySql is slick because just = qry from src and load to dst ... Is there any way to somehow show more of t= he error in PS i tried the $error but nothing very descriptive=C2=A0
<= br>
On Wed,= Feb 5, 2025 at 4:23=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.com> wro= te:
On 2/5/25 13= :09, Andy Hartman wrote:
> I also reduced batch size to 5000 on the last run=C2=A0 .. I like usin= g this
> SImplySql because=C2=A0it's a script I can launch, so that's w= hy I chose that
> solution...=C2=A0 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.klave= r@aklaver.com

--0000000000007a2864062d6d139e--