From: Adrian Klaver <adrian.klaver@gmail.com>
To: Kjell Øygard <kjellinge.oygard@ecc.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_restore problem
Date: Thu, 13 Sep 2012 06:46:03 -0700
Message-ID: <5051E39B.3080803@gmail.com> (raw)
In-Reply-To: <CAGo6516nqQet8j9CF4OirVogFFcwqO65ePco=C7OsZ3Np4HQtA@mail.gmail.com>
References: <CAGo6516nqQet8j9CF4OirVogFFcwqO65ePco=C7OsZ3Np4HQtA@mail.gmail.com>
On 09/12/2012 12:23 AM, Kjell Øygard wrote:
> 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
Several things:
1) The production version of 9,2 is out(9.2.0).
2) When you did the dump from 9.1.4 did you use the 9.1.4 or 9.2 version
of pg_dump?
3) What was the pg_dump command you used?
>
> --
> Rgds
> Kjell Inge Øygard
> Electronic Chart Centre
> www.ecc.no <http://www.ecc.no;
>
--
Adrian Klaver
adrian.klaver@gmail.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@gmail.com, kjellinge.oygard@ecc.no
Subject: Re: pg_restore problem
In-Reply-To: <5051E39B.3080803@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox