Re: psql \copy hanging

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: psql \copy hanging
Дата
Msg-id CAKoxK+6HcC+Qh-nHbgVNkJotH5cjbZjCq1J-z-8cDzY7hTRQnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
Ответы Re: psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
Список 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 по дате отправления:

Предыдущее
От: Sonam Sharma
Дата:
Сообщение: Re: vaccum in background
Следующее
От: "Arnaud L."
Дата:
Сообщение: Re: psql \copy hanging