pgAdmin3 restore data only - Mailing list pgadmin-support

From David Burton
Subject pgAdmin3 restore data only
Date
Msg-id B8EA3B46-F430-43B5-84BF-C0BD826889BA@gmail.com
Whole thread Raw
Responses Re: pgAdmin3 restore data only
List pgadmin-support
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

pgadmin-support by date:

Previous
From: Pieter du Plooy
Date:
Subject: Opensuse 12.3 build
Next
From: Pieter du Plooy
Date:
Subject: Re: Opensuse 12.3 build