"Karl O. Pinc" <kop@xxxxxxxx> 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
