Hi , Because of problem with Postgres 12 / Postgis 2.5.5 on Centos 8 we test to install Postgres 12 / Postgis 3.0. In the pats i have used your script postgis_restore.pl and this script is again present in the directory /usr/pgsql-12/share/contrib/postgis-3.0/. In this script i find : # # Copyright (C) 2009 Paul Ramsey <pram...@cleverelephant.ca<mailto:pram...@cleverelephant.ca>> # Tested on: # # pg-8.4.9/pgis-1.4.3 => pg-8.4.9/pgis-2.0.0SVN # pg-8.4.9/pgis-2.0.0SVN => pg-8.4.9/pgis-2.0.0SVN # pg-8.4.9/pgis-2.0.0SVN => pg-9.1.2/pgis-2.0.0SVN # pg-9.1b3/pgis-1.5.3 => pg-9.1.1/pgis-2.0.0SVN On the server postgis 2.5.5 i dump with -Fc and on the new (Postgis3) i use the script with some mistakes : ERREUR: la relation « geometry_columns » n'existe pas LIGNE 1 : UPDATE topology.topology t set srid = g.srid FROM geometry_c... ^ ERREUR: la relation « spatial_ref_sys » n'existe pas LIGNE 1 : UPDATE spatial_ref_sys o set auth_name = n.auth_name, auth_s... ^ ERREUR: la relation « spatial_ref_sys » n'existe pas LIGNE 1 : INSERT INTO spatial_ref_sys SELECT * FROM _pgis_restore_spat... ^ ERREUR: la relation « spatial_ref_sys » n'existe pas ERREUR: la relation « spatial_ref_sys » n'existe pas ERREUR: la relation « spatial_ref_sys » n'existe pas It seems that the restore is ok but what is your opinion about using this perl script today ?? Thank you for advance. Alain. [INRA]
Alain BENARD Administrateur Systèmes d'Information alain.ben...@inra.fr<mailto:alain.ben...@inra.fr> Unité SILVA Tél. : +33 3 83 39 40 84 Route d'amance 54 280 Champenoux inra.fr<http://www.inra.fr> [INRA]
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
