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

From Arnaud L.
Subject Re: psql \copy hanging
Date
Msg-id 171491de-b8e1-7f0d-0724-4d06a7902cc0@codata.eu
Whole thread Raw
In response to Re: psql \copy hanging  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: psql \copy hanging
List pgsql-general
Le 03/10/2019 à 15:54, Adrian Klaver a écrit :
> On 10/2/19 11:51 PM, Arnaud L. wrote:
>> Well, this problem is still bugging me, and this time I've tried with a 
>> local file. Unfortunately, it did not help.
>> To further rule out filesystem problems, I first took care to delete the 
>> target files before copying to it, but it did not help either.
>> 
>> So now I'm quite confident that the problem is either psql or even 
>> postgresql itself.
>> 
>> Does anyone know of anything I could try to try to fix or debug this ?
> 
> Going back to the original thread I noticed it was not specified what
> program was being used to run the script in the overnight session.
> 
> So what is being used to run the script overnight?


Yes, sorry for having lost the original thread, my mailbox has a quite 
stupid automatic purge schedule...

The script is run in a windows batch file.
Basically, export.bat contains :

SET PGUSER=myuser
SET PGPASSWORD=mypwd
SET PGCLIENTENCODING=UTF8
SET MYPGSERVER=myserverurl
SET MYPGDB=mydatabase
psql -h %MYPGSERVER% -a -f myscript.sql %MYPGDB%

And myscript.sql contains :
\copy (SELECT * FROM view1) TO '\\server\share\view1.txt'
\copy (SELECT * FROM view2) TO '\\server\share\view2.txt'
...
etc with ~60 views

Today, I've update the problematic \copy line to be :
COPY (SELECT * FROM view) TO STDOUT \g '\\server\share\view.txt'

I'll keep you informed (even though a successfull run is not a guarantee 
of success, because the original script did sometimes work).

Regards
--
Arnaud



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql \copy hanging
Next
From: Adrian Klaver
Date:
Subject: Re: psql \copy hanging