Re: 'invalid command \N' during restore from pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 'invalid command \N' during restore from pg_dump
Дата
Msg-id 20723.1224284775@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 'invalid command \N' during restore from pg_dump  (kevin kempter <kevin@kevinkempterllc.com>)
Список pgsql-admin
kevin kempter <kevin@kevinkempterllc.com> writes:
> I'm trying to run a restore from a pg_dump and I get loads of these:
> invalid command \N

It sounds like you had an error in a COPY command, which caused psql
not to go into copy-data-eating mode but instead keep trying to read
the data as SQL commands.

Generally speaking, looking at the *first* error is the most informative
way to proceed --- all the rest may just be cascading failures.

            regards, tom lane

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

Предыдущее
От: kevin kempter
Дата:
Сообщение: Re: 'invalid command \N' during restore from pg_dump
Следующее
От: "Ibrahim Harrani"
Дата:
Сообщение: Re: pg_standby and continuous recovery