Re: Backup Restore

Found it in template 1. This seems strange as both servers and pgadmins are
the same version and I haven't opened the template until today.

Bob

----- Original Message -----
From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Dave Page" <dpage(at)postgresql(dot)org>; "Shoaib Mir" <shoaibmir(at)gmail(dot)com>;
"Postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 03, 2007 10:44 AM
Subject: Re: [GENERAL] Backup Restore

> Bob Pawley wrote:
>> Looking through PGAdmin where would I find the spatial references that
>> the errror message references?
>
>>> Bob Pawley wrote:
>>>> 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..."
>
> Looking at this, you should have a table "spatial_ref_sys" with a primary
> key constraint "spatial_ref_sys_pkey"
>
> Find the table via the left-hand tree conrol and its details should be
> listed on the right-hand side. The primary key will be detailed at the top
> and bottom
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>