psql database recovery error

From: pgomez(at)freesurf(dot)ch (pgomez)
To: pgsql-admin(at)postgresql(dot)org
Subject: psql database recovery error
Date: 2002-09-12 09:10:19
Message-ID: 6064f39b.0209120110.4b0cb6fe@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message shreedhar 2002-09-12 09:47:35 Is it possible 'Rollback' and 'Commit' Transactions in postgre functions
Previous Message Mats Lofkvist 2002-09-12 08:29:46 Re: fsync or fdatasync