public inbox for [email protected]  

help / color / mirror / Atom feed

Re: load fom csv
6+ messages / 3 participants
[nested] [flat]

* Re: load fom csv
@ 2024-09-17 15:35 Andy Hartman <[email protected]>
  2024-09-17 15:39 ` Re: load fom csv Adrian Klaver <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Andy Hartman @ 2024-09-17 15:35 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; [email protected]

I don't see anything in LOG

On Tue, Sep 17, 2024 at 11:23 AM Adrian Klaver <[email protected]>
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
> [email protected]
>
>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: load fom csv
  2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
@ 2024-09-17 15:39 ` Adrian Klaver <[email protected]>
  2024-09-17 16:21   ` Re: load fom csv Andy Hartman <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Adrian Klaver @ 2024-09-17 15:39 UTC (permalink / raw)
  To: Andy Hartman <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; [email protected]

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-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 AM Adrian Klaver 
> <[email protected] <mailto:[email protected]>> 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
>     [email protected] <mailto:[email protected]>
> 

-- 
Adrian Klaver
[email protected]







^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: load fom csv
  2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 15:39 ` Re: load fom csv Adrian Klaver <[email protected]>
@ 2024-09-17 16:21   ` Andy Hartman <[email protected]>
  2024-09-17 16:25     ` Re: load fom csv Adrian Klaver <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Andy Hartman @ 2024-09-17 16:21 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; [email protected]

The command work outside of powershell  yes

On Tue, Sep 17, 2024 at 11:39 AM Adrian Klaver <[email protected]>
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-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 AM Adrian Klaver
> > <[email protected] <mailto:[email protected]>> 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
> >     [email protected] <mailto:[email protected]>
> >
>
> --
> Adrian Klaver
> [email protected]
>
>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: load fom csv
  2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 15:39 ` Re: load fom csv Adrian Klaver <[email protected]>
  2024-09-17 16:21   ` Re: load fom csv Andy Hartman <[email protected]>
@ 2024-09-17 16:25     ` Adrian Klaver <[email protected]>
  2024-09-17 19:45       ` Re: load fom csv Rob Sargent <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Adrian Klaver @ 2024-09-17 16:25 UTC (permalink / raw)
  To: Andy Hartman <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; [email protected]

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.


-- 
Adrian Klaver
[email protected]







^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: load fom csv
  2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 15:39 ` Re: load fom csv Adrian Klaver <[email protected]>
  2024-09-17 16:21   ` Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 16:25     ` Re: load fom csv Adrian Klaver <[email protected]>
@ 2024-09-17 19:45       ` Rob Sargent <[email protected]>
  2024-09-17 23:10         ` Re: load fom csv Andy Hartman <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Rob Sargent @ 2024-09-17 19:45 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Andy Hartman <[email protected]>; Muhammad Usman Khan <[email protected]>; [email protected]



> On Sep 17, 2024, at 12:25 PM, Adrian Klaver <[email protected]> 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

> 
> 






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: load fom csv
  2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 15:39 ` Re: load fom csv Adrian Klaver <[email protected]>
  2024-09-17 16:21   ` Re: load fom csv Andy Hartman <[email protected]>
  2024-09-17 16:25     ` Re: load fom csv Adrian Klaver <[email protected]>
  2024-09-17 19:45       ` Re: load fom csv Rob Sargent <[email protected]>
@ 2024-09-17 23:10         ` Andy Hartman <[email protected]>
  0 siblings, 0 replies; 6+ messages in thread

From: Andy Hartman @ 2024-09-17 23:10 UTC (permalink / raw)
  To: Rob Sargent <[email protected]>; +Cc: Adrian Klaver <[email protected]>; Muhammad Usman Khan <[email protected]>; [email protected]

I'll echo vars and see if something looks strange.

THanks.

On Tue, Sep 17, 2024 at 3:46 PM Rob Sargent <[email protected]> wrote:

>
>
> > On Sep 17, 2024, at 12:25 PM, Adrian Klaver <[email protected]>
> 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
>
> >
> >
>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

end of thread, other threads:[~2024-09-17 23:10 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-17 15:35 Re: load fom csv Andy Hartman <[email protected]>
2024-09-17 15:39 ` Adrian Klaver <[email protected]>
2024-09-17 16:21   ` Andy Hartman <[email protected]>
2024-09-17 16:25     ` Adrian Klaver <[email protected]>
2024-09-17 19:45       ` Rob Sargent <[email protected]>
2024-09-17 23:10         ` Andy Hartman <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox