"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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster