Re: pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Infor Gates <info_gates(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore
Date: 2006-06-17 16:38:51
Message-ID: 21690.1150562331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Infor Gates <info_gates(at)yahoo(dot)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

In response to

  • pg_restore at 2006-06-16 02:37:57 from Infor Gates

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Farrell,Bob 2006-06-17 17:01:13 Win32 2003 Front end
Previous Message Tom Lane 2006-06-17 16:36:42 Re: pg_dump: COPY vs INSERT