| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: psql database recovery error |
| Date: | 2002-09-16 20:48:27 |
| Message-ID: | 20020916164827.X4394@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-16 21:27:38 | Re: auto removing stale pid for postmaster NT service |
| Previous Message | Andrew Sullivan | 2002-09-16 20:41:29 | Re: auto removing stale pid for postmaster NT service |