On Fri, Feb 28, 2014 at 11:55 PM, <rajkumarmca1488(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 9384
> Logged by: Rajkumar.K
> Email address: rajkumarmca1488(at)gmail(dot)com
> PostgreSQL version: 9.3.2
> Operating system: Linux CentsOs 6.4
> Description:
>
> Fine i have taken backup of my database using "pg_dump" utility(dump file
> name is "testbackup.sql").Before restoring it back,i dropped all
> tables,view,sequences,functions which i have created. After that using
> "psql" command try to restore the dump back.But it shows the duplicate-key
> violation error.
> Error : psql.bin:testbackup.sql:17884: ERROR: duplicate key value violates
> unique constraint "pg_largeobject_metadata_oid_index".I googled in internet
> but i cant come to a correct solution.so Kindly provide us theproper
> solution.
There is no bug here. The error you are seeing is caused by an
existing large object, which is something different from the objects
you seem to have manually dropped:
http://www.postgresql.org/docs/devel/static/largeobjects.html
If you are going to use the same server to restore the data taken from
the dump, you should at least remove those large objects as well...
--
Michael