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
