[postgis-users] TR: postgis_restore.pl

[Alain Benard]

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 <pramsey at cleverelephant.ca<mailto:pramsey at 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.benard at inra.fr<mailto:alain.benard at 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]




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210625/9ab3485f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 187 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210625/9ab3485f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 174 bytes
Desc: image004.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210625/9ab3485f/attachment-0001.png>