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

From Luca Ferrari
Subject Re: psql \copy hanging
Date
Msg-id CAKoxK+6HcC+Qh-nHbgVNkJotH5cjbZjCq1J-z-8cDzY7hTRQnw@mail.gmail.com
Whole thread Raw
In response to Re: psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
Responses Re: psql \copy hanging
List pgsql-general
On Wed, Aug 28, 2019 at 9:09 AM Arnaud L. <arnaud.listes@codata.eu> wrote:
> OK, so this was enough for last night's schedule to run without problem.
> I still don't get it so I'm not satisfied with this solution, but at
> least it works.
> I'll keep the list informed if something new arises.

I don't want to be pedantic, but I would have tried with a single
change at a time.
And my bet is: the local file would do the trick (i.e., it is a weird
share problem).

If you are going to invest some time, you could also try to write a
small file on the share just before the copy starts, so that you are
guaranteed the share is working. Something like:

echo $(date) >> $SHARE/log.txt
psql 'copy ...'
echo 'done' >> $SHARE/log.txt

Luca



pgsql-general by date:

Previous
From: Sonam Sharma
Date:
Subject: Re: vaccum in background
Next
From: "Arnaud L."
Date:
Subject: Re: psql \copy hanging