Postgres Pro
Downloads
Home   >   mailing lists

psql database recovery error - Mailing list pgsql-admin

From pgomez@freesurf.ch (pgomez)
Subject psql database recovery error
Date
Msg-id 6064f39b.0209120110.4b0cb6fe@posting.google.com
Whole thread Raw
Responses Re: psql database recovery error  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tony_Chao@putnam.com
Date:
Subject: auto removing stale pid for postmaster NT service
Next
From: info
Date:
Subject: -i option