Re: pg_restore PostgreSQL 9.3.3 problems - Mailing list pgsql-bugs

From bricklen
Subject Re: pg_restore PostgreSQL 9.3.3 problems
Date
Msg-id CAGrpgQ98+Yj6N4YXpbMLsSDwjUef-4QXePofsj7hti75sr_AhQ@mail.gmail.com
Whole thread Raw
In response to pg_restore PostgreSQL 9.3.3 problems  ("Burgess, Freddie" <FBurgess@Radiantblue.com>)
List 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 by date:

Previous
From: "Burgess, Freddie"
Date:
Subject: pg_restore PostgreSQL 9.3.3 problems
Next
From: Tom Lane
Date:
Subject: Re: BUG #10611: pg_restore incorrectly restores DB dump (plain and tar format) containing LARGE OBJECTS witdh commen