Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group