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

FAQ