[postgis-users] [Partially solved] Re: Upgrade from Postgis 1.5.1-5 to 2.3.1

[Michel Philippenko]

Hello,
I have managed to avoid errors in relation with spatial_ref_sys_srid_check
and I asked the administrators of the website postgis.net to add some
information in this page :
https://postgis.net/docs/postgis_installation.html#hard_upgrade
in the chapter :
"Some custom records of spatial_ref_sys in dump file have an invalid SRID
value"

Information to insert :
"Typically, if you use the french system IGN, you will have problems with
SRID values out of range. You need first to throw out completely the IGN
from the sql which is resulting from postgis_restore.pl. So, first run :
perl utils/postgis_restore.pl "/somepath/olddb.backup" > oldbb.sql
then
grep -v IGNF olddb.sql > olddb-without-IGN.sql
then create your newdb, activate the required Postgis extensions, and
insert properly the french system IGN with this script :
https://raw.githubusercontent.com/Remi-C/IGN_spatial_ref_for_PostGIS/master/Put_IGN_SRS_into_Postgis.sql
then, to finish, run :
psql -h localhost -p 5432 -U postgres -d newdb -f olddb-without-IGN.sql  2>
errors.txt
"
Thank you very much for you attention,
With best regards,
Mikhael Philippenko.

Le jeu. 8 nov. 2018 à 14:55, Michel Philippenko <michel.ing93 at gmail.com> a
écrit :

> Hello,
> I'm new with Postgis.
> I'm upgrading a database from Postgis 1.5.1-5 to 2.3.1 following the
> instructions given on this web page :
> https://postgis.net/docs/postgis_installation.html#hard_upgrade.
> The errors below are displayed when importing my dump. Will my DB work
> well ? Should I fight more to have no errors at all ?
> Thank you for your help and your attention.
> With best regards,
> Mikhael.
>
> ERREUR:  la famille d'opérateur « btree_geography_ops » existe déjà pour
> la méthode d'accès « btree »
> ERREUR:  la famille d'opérateur « btree_geometry_ops » existe déjà pour la
> méthode d'accès « btree »
> ERREUR:  la famille d'opérateur « gist_geography_ops » existe déjà pour la
> méthode d'accès « gist »
> ERREUR:  la contrainte de vérification « spatial_ref_sys_srid_check » est
> rompue par une ligne
> ERREUR:  n'a pas pu créer l'index unique « spatial_ref_sys_pkey »
> DÉTAIL : La clé (srid)=(999954) est dupliquée.
>
> My translation in English :
> ERROR:  the operator family « btree_geography_ops » already exists for the
> access method « btree »
> ERROR:  the operator family « btree_geometry_ops »already exists for the
> access method « btree »
> ERROR:  the operator family « gist_geography_ops » already exists for the
> access method « gist »
> ERROR:  the constraint check « spatial_ref_sys_srid_check » is broken  for
> one line
> ERROR:  could not create the uniq index « spatial_ref_sys_pkey »
> DETAIL : The key (srid)=(999954) is duplicated.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181109/382c0a80/attachment.html>