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 1sqaxb-00B2vA-6d for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 16:21:52 +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 1sqaxa-00DDxD-7U for pgsql-general@arkaria.postgresql.org; Tue, 17 Sep 2024 16:21:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqaxZ-00DDx3-QR for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 16:21:49 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqaxV-001fzN-AW for pgsql-general@lists.postgresql.org; Tue, 17 Sep 2024 16:21:49 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-e1a989bd17aso4043312276.1 for ; Tue, 17 Sep 2024 09:21:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726590105; x=1727194905; 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=UucbsJdUuyWuexXSorzsZ6FvRpIrqX3rfVBFXcqMqFo=; b=N3xUOkWB+F57HSdgWW6p9ozGSUsunfRF+1CEU1ADc6TUcSou62bNIqFCv7Y+/gNVFv C37lJXi41HI/AaM35/t7fDWNhiRI55QoRDGQFZPCvlddEjlMZxLUzpZc7sFTVxlwRFDp +mG9Sbsd5a79qCPCfcWsw5AD6kUTJfF8T4YdEWZ+ycEtqtTGW7g48z7eAirZdZ/7OdBq tZBFA7bf7/o9Yle/NYOzh6wUF63Iwziy1stix7sM7Dv1mB1dTqKPdidGcM3y2e/R8ST7 chTLHfhC9pQprujm3iobb97UO26v7uaKKtsciMOrXjw5uvgDUkY3dy7rhitPfxq9mbc+ Rv2A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726590105; x=1727194905; 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=UucbsJdUuyWuexXSorzsZ6FvRpIrqX3rfVBFXcqMqFo=; b=ItckSMEjj28WVCBw2qmcvhuutxFArenGZYC+2mhEuEMH4Ds2sYIqlLw3wmtRUG+H1D D+X2x+RlSIHU+H9Ktx/hrcW12Nl3kt0fZ0JYiN/EE3OD7xe0BKCmUpULb/clUQ/ny4p+ NA78Yo5xbwcX6McObdQg6TSlPyzZ8ICkLclQlf0g6A3KorfIZD5Fe+laLjzTWTPfWCiR a32YwnSDb5SBqo2uybyMvY5NGSHTHVwdLh81SHck7NyW/26ZVjEZMNG39AhqHr0VnCt8 A7R6xAczZsnQfEKQJX1cSq1Bt83awHUhgGfF+9rBz8eYKsZOY5JnrzC/Pgl7GTHqR2CW mlag== X-Forwarded-Encrypted: i=1; AJvYcCXFM9k625jo2m7bf9saEL7c1//LNhepQuCcv2X49NNVOZHrGQ+mKGakewfxQ2cl/T9kWNADezvlekyw1wZX@lists.postgresql.org X-Gm-Message-State: AOJu0YxRhQfq75jFV3OxTz2mweiVhI5PGtG+SGWi2IAbSBlYQh8qwzI1 wlSwgaKjNZ8VAZVFZmo+J6rMHjxUDGPRNkfmMwxAFUnQKTpLkWSfuEqah5/ynJMy6s8eUsmkqEO H3F0Ho1o/nWKFKnpPfoLxJ267Xm+DXXQE X-Google-Smtp-Source: AGHT+IEToIPljrkqYgj2J/8Y0MuYMbgDo1HBmz7+t9+tsOZUBsGOZuGdo6C4Jzy1xIKPcFkd5Cu8bfsUiUaSw1WXYTA= X-Received: by 2002:a05:6902:2186:b0:e1d:2261:cb25 with SMTP id 3f1490d57ef6-e1db00c664amr11111713276.18.1726590104866; Tue, 17 Sep 2024 09:21:44 -0700 (PDT) MIME-Version: 1.0 References: <52be0330-2909-4e15-9445-5c5a3ca2a41c@aklaver.com> <41094c66-84e0-4434-81c1-8189bea90665@aklaver.com> In-Reply-To: <41094c66-84e0-4434-81c1-8189bea90665@aklaver.com> From: Andy Hartman Date: Tue, 17 Sep 2024 12:21:33 -0400 Message-ID: Subject: Re: load fom csv To: Adrian Klaver Cc: Muhammad Usman Khan , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000df9955062253155f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000df9955062253155f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The command work outside of powershell yes On Tue, Sep 17, 2024 at 11:39=E2=80=AFAM Adrian Klaver wrote: > On 9/17/24 08:35, Andy Hartman wrote: > > I don't see anything in LOG > > 1) Are you logging connections/disconnection per?: > > > https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTI= ME-CONFIG-LOGGING-WHAT > > If not do so as it will show you if a connection is being attempted. > > 2) Do the commands work when run in psql or supplied directly to psql > outside of PowerShell? > > > > > > On Tue, Sep 17, 2024 at 11:23=E2=80=AFAM Adrian Klaver > > > wrote: > > > > On 9/17/24 08:13, Andy Hartman wrote: > > > Still when I try to run from my powershell script it hangs... > > > > > > > And the Postgres log shows? > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > --000000000000df9955062253155f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
The command work outside of powershell=C2=A0 yes

=
On Tue, Se= p 17, 2024 at 11:39=E2=80=AFAM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 9/17/24 08:35, Andy Hartman = wrote:
> I don't see anything in LOG

1) Are you logging connections/disconnection per?:

https= ://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONF= IG-LOGGING-WHAT

If not do so as it will show you if a connection is being attempted.

2) Do the commands work when run in psql or supplied directly to psql
outside of PowerShell?


>
> On Tue, Sep 17, 2024 at 11:23=E2=80=AFAM Adrian Klaver
> <adr= ian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0On 9/17/24 08:13, Andy Hartman wrote:
>=C2=A0 =C2=A0 =C2=A0 > Still when I try to run from my powershell sc= ript it hangs...
>=C2=A0 =C2=A0 =C2=A0 >
>
>=C2=A0 =C2=A0 =C2=A0And the Postgres log shows?
>
>=C2=A0 =C2=A0 =C2=A0--
>=C2=A0 =C2=A0 =C2=A0Adrian Klaver
>=C2=A0 =C2=A0 =C2=A0adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com><= br> >

--
Adrian Klaver
adrian.klave= r@aklaver.com

--000000000000df9955062253155f--