[postgis-users] Upgrade both Postgres/postgis and Debian major releases - how to?
aperi2007 at gmail.com
Wed Aug 16 02:13:37 PDT 2017
Perhaps some grant rule change between 9.4 and 9.6 that give unseeable the
spatialrefsys to other tables ?
Il 16 Ago 2017 09:47, "Pietro Rossin" <pietro.rossin at arpa.fvg.it> ha
we made a hard upgrade and the result seems ok, but a long errors list
reported by the process..
In order, in debian 8.9/postgresql 9.4.12/postgis 2.3 we made a custom dump
pg_dump -Fc -b -v -f "/somepath/olddb.backup" olddb
then we upgraded debian to 9, postgresql to 9.6/postgis 2.3
perl some_path_to/postgis_restore.pl "/somepath/olddb.backup" | psql newdb
The restore process came to the end and in errors.txt we find many errors
ERROR: GetProj4StringSPI: Cannot find SRID (3045) in spatial_ref_sys
or other srid..
So I tried to compare what is in both db (old/new) and
public.spatial_ref_sys has these srid, the public.geometry_columns content
is the same in old/new view and the number of tables/records is the same
(except some difference in count due to vacuum execution)
So for me the dump/restore process seems good this way, but what about these
View this message in context: http://postgis.17.x6.nabble.
Sent from the PostGIS - User mailing list archive at Nabble.com.
postgis-users mailing list
postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users