Thread: pgAdmin3 restore data only
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
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:
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