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