Re: psql \copy hanging

Le 08/10/2019 à 09:28, Pavel Stehule a écrit :
> you can write simple C application with COPY API
> https://www.postgresql.org/docs/12/libpq-copy.html

Unfortunately, I don't know C.

> Then you can eliminate or ensure locality of problem.
>
> more, you can use server side copy. Superuser can read data from server
> file system.

Yes, but in this case the file has to be written to a network share, and
the windows user under wich PostgreSQL runs (Network Service) cannot be
given write permission on this share.
That's the reason for the use of \copy.

Now that I think about it, *maybe* this started happening after a server
upgrade. Since this is intermittent, I'm not really sure about this, but
some time ago we moved our server to a different hardware and upgraded
from 9.3 to 11 at the same time.
The dates don't perfectly match though, we upgraded around 8th of august
and the problem arose ~2 weeks later for the first time.
The client was upgraded around that same time period (not exactly the
same time if I remember correctly).

Regards
--
Arnaud