Re: Backup Restore

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: Shoaib Mir <shoaibmir(at)gmail(dot)com>, Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backup Restore
Date: 2006-12-29 19:26:52
Message-ID: 001901c72b7f$5a5e29f0$8e904618@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Following is the error message on pg_restore:-

"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_pkey"
CONTEXT: COPY spatial_ref_sys, line 1: "2000 EPSG 2000 PROJCS["Anguilla
1957 / British West Indies Grid",GEOGCS["Anguilla 1957",DATUM["Angui..."
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR: duplicate
key violates unique constraint "spatial_ref_sys_pkey"
CONTEXT: COPY spatial_ref_sys, line 1: "2000 EPSG 2000 PROJCS["Anguilla
1957 / British West Indies Grid",GEOGCS["Anguilla 1957",DATUM["Angui..."
pg_restore: *** aborted because of error

Process returned exit code 1."

The GIS feature was removed from the PostgreSQL application before the
project dump.

Anyone have any thoughts on how to get around this??

Bob

----- Original Message -----
From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>; "Postgresql"
<pgsql-general(at)postgresql(dot)org>
Sent: Friday, December 29, 2006 10:57 AM
Subject: Re: [GENERAL] Backup Restore

> Bob Pawley wrote:
>> Hi Dave
>>
>> I can get the restore working if I dump the project spelling out
>> "*.backup" and not relying on the default.
>>
>> However the restore is being aborted due to a pk error for the spatial
>> coordinates. I've removed the gis feature from both applications but
>> still get the error.
>>
>> Any thoughts??
>
> Nope, someone else will need to help with that I'm afraid. The exact error
> message would make it infinitely easier to help you though.
>
> Regards, Dave
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Finner 2006-12-29 19:28:25 Re: slow speeds after 2 million rows inserted
Previous Message Dave Page 2006-12-29 18:57:19 Re: Backup Restore