"Karl O. Pinc" <kop(at)meme(dot)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