Perry Smith <pedz...@gmail.com> writes: > I am doing a restore: > > pg_restore --no-owner -L /tmp/db.list --single-transaction > --dbname=condor3_production $DBFILE > > and I get this error: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 2056; 0 35202 TABLE DATA > adv_ptf_release_maps pedzan > pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates > unique constraint > "adv_ptf_release_maps_apar_defect_version_map_id_ptf_id_rele_key" > DETAIL: Key (apar_defect_version_map_id, ptf_id, release_id)=(72022, 16678, > 436) already exists. > CONTEXT: COPY adv_ptf_release_maps, line 651290: "651290 72022 16678 > 436 2009-06-07 14:08:55.627762 2009-06-07 14:08:55.627762" > > I've used the custom format. The error tells me a line number but I can't > look at it. Is there a way that I can convert the custom format to something > I can view? > > Also, I have turned off all the foreign key checking while I was > doing the restore but I guess this is the unique checking that is > causing the error. Can I turn that off (without doing a table > modify)?
I think you are restoring into a DB with non-empty tables. Your target DB/tables needs either... a. to be initially empty b. to be populated with non-conflicting data c. dump and/or restore invoked using 'clean' options Or even possibly you are restoring a data-only dump from a non-constrained origin system into one with unique constraints. HTH > > Thank you, > Perry > > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
