| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | "Burgess, Freddie" <FBurgess(at)radiantblue(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: pg_restore PostgreSQL 9.3.3 problems |
| Date: | 2014-06-12 21:08:14 |
| Message-ID: | CAGrpgQ98+Yj6N4YXpbMLsSDwjUef-4QXePofsj7hti75sr_AhQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Jun 12, 2014 at 1:25 PM, Burgess, Freddie <FBurgess(at)radiantblue(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-06-13 00:23:49 | Re: BUG #10611: pg_restore incorrectly restores DB dump (plain and tar format) containing LARGE OBJECTS witdh commen |
| Previous Message | Burgess, Freddie | 2014-06-12 20:25:20 | pg_restore PostgreSQL 9.3.3 problems |