Re: pg_restore duplicate key violations

"Karl O. Pinc" <kop@meme.com> writes:
> I'm having trouble with a dump and restore:

> $ pg_dump --format=t --schema=babase --data-only --user babase_admin
> babase_test | pg_restore --data-only --disable-triggers --user
> babase_admin --dbname=babase
> pg_restore: ERROR:  duplicate key violates unique constraint
> "activities_pkey"
> CONTEXT:  COPY activities, line 1: "B   t       t       Be groomed"

Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...

            regards, tom lane