Content-Type: multipart/alternative; boundary=Apple-Mail-8E59F1DE-55EA-4CC0-9948-1EA37C9C3B48
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: load fom csv
Date: Wed, 18 Sep 2024 07:29:57 -0600
Message-Id: <75301205-13E6-4C65-9D70-78F196937F69@gmail.com>
References: <CAEZv3cp2hTWDXjbfGt2uTWb=j5FoS0DpbdzzQwTO2QKuxzZrPg@mail.gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 Muhammad Usman Khan <usman.k@bitnine.net>,
 pgsql-general@lists.postgresql.org
In-Reply-To: <CAEZv3cp2hTWDXjbfGt2uTWb=j5FoS0DpbdzzQwTO2QKuxzZrPg@mail.gmail.com>
To: Andy Hartman <hartman60home@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/75301205-13E6-4C65-9D70-78F196937F69%40gmail.com>
Precedence: bulk


--Apple-Mail-8E59F1DE-55EA-4CC0-9948-1EA37C9C3B48
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br=
></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Sep 18, 2024, at 6:=
39=E2=80=AFAM, Andy Hartman &lt;hartman60home@gmail.com&gt; wrote:<br><br></=
blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div di=
r=3D"ltr"><div dir=3D"ltr">psql -h $pgServer -d $pgDatabase -U $pgUser -c $c=
opyCommand&nbsp;</div><div dir=3D"ltr"><br></div><div>I'm wondering if it's w=
aiting on P/w ?<br><br>Thanks.</div></div></div></blockquote><div><br></div>=
Very likely. &nbsp;Can you show the authentication&nbsp;<div>mechanisms used=
 (pg_hba)?<br><blockquote type=3D"cite"><div dir=3D"ltr"><br><div class=3D"g=
mail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Sep 17, 2024 at 7:=
10=E2=80=AFPM Andy Hartman &lt;<a href=3D"mailto:hartman60home@gmail.com">ha=
rtman60home@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div dir=3D"ltr">I'll echo vars and see if something look=
s strange.<br><br>THanks.</div><br><div class=3D"gmail_quote"><div dir=3D"lt=
r" class=3D"gmail_attr">On Tue, Sep 17, 2024 at 3:46=E2=80=AFPM Rob Sargent &=
lt;<a href=3D"mailto:robjsargent@gmail.com" target=3D"_blank">robjsargent@gm=
ail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><br>
<br>
&gt; On Sep 17, 2024, at 12:25=E2=80=AFPM, Adrian Klaver &lt;<a href=3D"mail=
to:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a=
>&gt; wrote:<br>
&gt; <br>
&gt; =EF=BB=BFOn 9/17/24 09:21, Andy Hartman wrote:<br>
&gt;&gt; The command work outside of powershell&nbsp; yes<br>
&gt; <br>
&gt; Then you are going to need to use whatever debugging tools PowerShell h=
as available to step through the script to figure out where the problem is.<=
br>
&gt; <br>
&gt; <br>
<br>
Visual Studio can run/debug PS 1 files. I am not at my desk but have done ps=
1 oneliner queries against mssql<br>
<br>
Suggest echoing ALL vars used in psql command<br>
<br>
&gt; <br>
&gt; <br>
</blockquote></div>
</blockquote></div>
</div></blockquote></div></body></html>=

--Apple-Mail-8E59F1DE-55EA-4CC0-9948-1EA37C9C3B48--