Re: pg_restore PostgreSQL 9.3.3 problems

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: pg_restore PostgreSQL 9.3.3 problems
Дата
Msg-id CAGrpgQ98+Yj6N4YXpbMLsSDwjUef-4QXePofsj7hti75sr_AhQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_restore PostgreSQL 9.3.3 problems  ("Burgess, Freddie" <FBurgess@Radiantblue.com>)
Список pgsql-bugs
On Thu, Jun 12, 2014 at 1:25 PM, Burgess, Freddie <FBurgess@radiantblue.com>
wrote:

>  *pg_restore -c -F c -j 3 -U postgres -d trackdb -v
> "trackdb.partial.dmp"*
>
> Error Condition:
>
> pg_restore: [archiver (db)] Error from TOC entry 575; 1259 618063 TABLE
> tracker_message postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop
> table tracker_message because other objects depend on it
> DETAIL:  constraint tracker_event_message_id_fkey on table
> tracker_event_message_underflow depends on table tracker_message
> constraint tracker_event_message_id_fkey on table
> tracker_event_message_y2010m01 depends on table tracker_message.
>

Does it make a difference  if you omit the "-j3" parallel option on restore?

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

Предыдущее
От: "Burgess, Freddie"
Дата:
Сообщение: pg_restore PostgreSQL 9.3.3 problems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #10611: pg_restore incorrectly restores DB dump (plain and tar format) containing LARGE OBJECTS witdh commen