Re: psql \copy hanging

On 8/22/19 7:07 AM, Arnaud L. wrote:
> Le 22/08/2019 à 16:00, Adrian Klaver a écrit :
>> The first thing I think of when seeing this sort of behavior on Windows
>> is anti-virus software. Doing you have any running on the machine?
>>
>> You say it always hangs on the same line. Is that line doing something
>> different from the others? Say writing to a different location.
> 
> Thanks for your insights Adrian.
> 
> There is no AV software on the machine as it is a Server version of 
> Windows. (I know some people run AV on Windows Server, but I don't)
> 
> All the lines write to the same location which is a network share, but 
> the hanging one is clearly the longest query to execute and the output 
> file is one of the biggest one (though not the biggest).

The only thing I can think of at the moment is to put the offending line 
in a separate script and see what happens.

> 
> Note that the share points to a local folder. The fact the psql writes 
> to a share is only for robustness so that this script could be executed 
> from any machine.
> 
> Cheers
> 
> -- 
> Arnaud
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com