Re: psql \copy hanging

Поиск
Список
Период
Сортировка
От Arnaud L.
Тема Re: psql \copy hanging
Дата
Msg-id ebfbdd2d-346d-f656-8b99-23c0ca50222c@codata.eu
обсуждение исходный текст
Ответ на Re: psql \copy hanging  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: psql \copy hanging  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: psql \copy hanging  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Le 07/10/2019 à 16:36, Adrian Klaver a écrit :
> So you are saying that you have not run the problematic line by itself?

It hung during last night's run.

I had modified my batch script to run the \copy commands separately, 
i.e. it now reads as :
psql -h myserver -a mydb < originalscriptwithoutproblematicline.sql
psql -h myserver -a mydb < problematicline.sql

It hung at the problematic line, so during the second psql command.

I'm really at loss... I *believe* that the problem lies either in psql 
or in PostgreSQL, but I really don't know what to try now.


Regards
--
Arnaud



В списке pgsql-general по дате отправления:

Предыдущее
От: Artur Zając
Дата:
Сообщение: RE: Table locking during backup
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: psql \copy hanging