Re: psql \copy hanging
От
Pavel Stehule
Тема
Re: psql \copy hanging
Дата
Msg-id
CAFj8pRCbOidyOMJ_0TPYdm0xKAJ2sHpC3VQdB_Mn05W0vgCF7g@mail.gmail.com
Ответ на
Re: psql \copy hanging (Arnaud L.)
Список
Дерево обсуждения
psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Pavel Stehule <pavel.stehule@gmail.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging "Daniel Verite" <daniel@manitou-mail.org>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging "Daniel Verite" <daniel@manitou-mail.org>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
Re: psql \copy hanging Adrian Klaver <adrian.klaver@aklaver.com>
Re: psql \copy hanging "Arnaud L." <arnaud.listes@codata.eu>
út 8. 10. 2019 v 9:06 odesílatel Arnaud L. <arnaud.listes@codata.eu> napsal:
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.
you can write simple C application with COPY API https://www.postgresql.org/docs/12/libpq-copy.html
Then you can eliminate or ensure locality of problem.
more, you can use server side copy. Superuser can read data from server file system.
Regards
Pavel
Regards
--
Arnaud
В списке pgsql-general по дате отправления
