Morning guys...
I have two servers , one with postgres 9.2rc1 and one with postgres 9.1.4.
I need to do a restore from a dump from 9.1.4 to 9.2rc1 and I get this
error:
pg_restore: [archiver (db)] Error from TOC entry 177675; 2613 579519 BLOB
579519 primar
pg_restore: [archiver (db)] could not execute query: ERROR: duplicate key
value violates unique constraint "pg_largeobject_metadata_oid_index"
DETAIL: Key (oid)=(579519) already exists.
Command was: SELECT pg_catalog.lo_create('579519');
This just keep repeat itself in the log.
The command used is: pg_restore -O -U user -d database2 database2.dump
>dump.log 2>&1 &
Appreciate any help
--
Rgds
Kjell Inge Øygard
Electronic Chart Centre
www.ecc.no
