Postgres Pro
Downloads
Home   >   mailing lists

Re: No restore of BLOB data (permissions?) - Mailing list pgsql-admin

From Tom Lane
Subject Re: No restore of BLOB data (permissions?)
Date
Msg-id 412.1188398966@sss.pgh.pa.us
Whole thread Raw
In response to Re: No restore of BLOB data (permissions?)  (Jordi Mulet <jmuletalbiach@yahoo.com>)
List pgsql-admin
Tree view 
Jordi Mulet <jmuletalbiach@yahoo.com> writes:
> Info on log file:
> 2007-08-29 08:46:52 ERROR: duplicate key violates unique constraint "pg_lar=
> geobject_loid_pn_index"

So the problem is you've already *got* that blob, or at least one with
the same OID, in the target database.  Try restoring into an empty
database.

            regards, tom lane

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: how is pitr replay interruption time determined?
Next
From: Robert Treat
Date:
Subject: Re: how is pitr replay interruption time determined?