Re: pgAdmin3 restore data only

Hi David,

Are you restoring into an empty database or an existing database? The
restore process does not clean out the data that is already in your
database, it just adds to it, so if you've previously restored your
database you merging your original and new copy of the data.

Cheers,

Bas

On 24/05/13 4:34 AM, David Burton wrote:
> 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