I have a development pg and a server pg. I would like to copy the data from production to development (and replace any data that is already in development). I ran a custom format backup using pgAdmin3 on production. I'm now trying to restore that backup to development. I checked the data-only option. But, I get the following errors:
pg_restore: [archiver (db)] COPY failed for table "actcodes": ERROR: duplicate key value violates unique constraint "actcodes_pkey"
Thanks,
David Burton