psql \copy hanging

From: "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: psql \copy hanging
Date: 2019-08-22 08:47:22
Message-ID: d5df5507-7491-5877-5412-c9325d0ec49c@codata.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list

On Windows, I have an unattended script that exports data overnight by
issuing psql commands like :
psql -f mycommands.sql
whith mycommands.sql containing a bunch of \copy lines like :
\copy (SELECT * FROM someview) TO
'\\windowsserver\windowsshare\somefile.csv'

When I run this script by hand, everything is fine but when it runs
overnight it hangs and allways on the same line.
There is no lock in the database, and the connection is marked as active
in the backend and running the statement "COPY (SELECT * FROM myview) TO
STDOUT".
So where can things be hanging ?
My first guess (appart from db lock) was that the target file was locked
by the filesystem. But wouldn't psql know about it and fail with an error ?

Thanks for your help !

--
Arnaud

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2019-08-22 12:25:29 Re: Importing from CSV, auto creating table?
Previous Message Adrian Klaver 2019-08-22 03:43:31 Re: Rename a column if not already renamed.?