pg_restore problem

From: Kjell Øygard <kjellinge(dot)oygard(at)ecc(dot)no>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_restore problem
Date: 2012-09-12 07:23:54
Message-ID: CAGo6516nqQet8j9CF4OirVogFFcwqO65ePco=C7OsZ3Np4HQtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Samuel Gendler 2012-09-12 07:24:42 Re: weird join producing too many rows
Previous Message Gary Stainburn 2012-09-11 14:42:09 weird join producing too many rows