Re: psql \copy hanging

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).

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