Обсуждение: psql database recovery error

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

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
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110