psql database recovery error
psql database recovery error
От:
pgomez@freesurf.ch (pgomez)
Дата:
Hi everybody, when I'm trying to recover the database using the command "psql database < database.file" I'm getting the error: "ERROR: copy line 1. Cannot insert duplicate key into unique index table_pkey lost synchronization with server, resetting connection" Thanks for help Philipp
Re: psql database recovery error
От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
On Thu, Sep 12, 2002 at 02:10:19AM -0700, pgomez wrote:
> Hi everybody,
>
> when I'm trying to recover the database using the command "psql
> database < database.file" I'm getting the error:
>
> "ERROR: copy line 1. Cannot insert duplicate key into unique index
> table_pkey
> lost synchronization with server, resetting connection"
Did you pg_dump with -c? Maybe the old data is in the database, so
you can't re-insert it?
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
M2P 2A8
+1 416 646 3304 x110