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