pgAdmin3 restore data only

From: David Burton <burtondav(at)gmail(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin3 restore data only
Date: 2013-05-23 18:34:24
Message-ID: B8EA3B46-F430-43B5-84BF-C0BD826889BA@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Pieter du Plooy 2013-05-23 18:51:05 Opensuse 12.3 build
Previous Message Dave Page 2013-05-23 15:37:42 Re: pgAdmin3 restore getting password authentication failed for user "postgres"