[postgis-users] [French IGN system] Could you add this in the postgis docs ?

Michel Philippenko michel.ing93 at gmail.com
Fri Nov 9 08:21:17 PST 2018


Could you add following information in the postgis docs in this page :
in the chapter :
"Some custom records of spatial_ref_sys in dump file have an invalid SRID

please be kind 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
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 :
then, to finish, run :
psql -h localhost -p 5432 -U postgres -d newdb -f olddb-without-IGN.sql  2>
Thank you very much,
With best regards,
Mikhael Philippenko.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181109/ab740131/attachment.html>

More information about the postgis-users mailing list