On Sep 18, 2024, at 6:39 AM, Andy Hartman <hartman60home@xxxxxxxxx> wrote:
psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand
I'm wondering if it's waiting on P/w ?
Thanks.
Very likely. Can you show the authentication mechanisms used (pg_hba)? I'll echo vars and see if something looks strange.
THanks.
> On Sep 17, 2024, at 12:25 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
>
> On 9/17/24 09:21, Andy Hartman wrote:
>> The command work outside of powershell yes
>
> Then you are going to need to use whatever debugging tools PowerShell has available to step through the script to figure out where the problem is.
>
>
Visual Studio can run/debug PS 1 files. I am not at my desk but have done ps1 oneliner queries against mssql
Suggest echoing ALL vars used in psql command
>
>
|
