Re: psql \copy hanging - Mailing list pgsql-general

From Arnaud L.
Subject Re: psql \copy hanging
Date
Msg-id b21e1847-d05b-d91f-284a-41f5a4e7b427@codata.eu
Whole thread Raw
In response to Re: psql \copy hanging  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: psql \copy hanging
List pgsql-general
Le 08/10/2019 à 16:55, Daniel Verite a écrit :
>     Arnaud L. wrote:
> 
>> Anyway, it hung using this syntax during last night's run.
>> I'll give it another try tonight  just to be sure.
> 
> When psql.exe is hanging, maybe you could use a tool like
> Process Monitor [1] or Process Explorer [2] to get insights about
> what it's stuck on or what it's doing exactly.
> 
> [1] https://docs.microsoft.com/en-us/sysinternals/downloads/procmon
> [2] https://docs.microsoft.com/en-us/sysinternals/downloads/process-explorer

Yes, I already did that, and unfortunately there's no activy.
There is absolutely no activity in procmon using psql.exe as a filter.
process-xp is not giving more information, processor usage is 0%.


Regards
--
Arnaud



pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: psql \copy hanging
Next
From: Tom Lane
Date:
Subject: Re: Table locking during backup