Re: pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore
Date
Msg-id 21690.1150562331@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore  (Infor Gates <info_gates@yahoo.com>)
Responses Re: pg_restore  (Infor Gates <info_gates@yahoo.com>)
List pgsql-admin
Infor Gates <info_gates@yahoo.com> writes:
> I hope you could help me understand the error message below:
> While it looks straight forward, I could NOT find the duplicate key violation,

Considering that it's complaining at the very first line of COPY data,
I wonder whether you aren't restoring into a table that already contains
the data you want to load.  pg_restore doesn't (by default) try to
delete data that's already present.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump: COPY vs INSERT
Next
From: Infor Gates
Date:
Subject: Re: pg_restore