[postgis-users] Upgrade both Postgres/postgis and Debian major releases - how to?
pietro.rossin at arpa.fvg.it
Wed Aug 16 00:47:52 PDT 2017
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.com/Upgrade-both-Postgres-postgis-and-Debian-major-releases-how-to-tp5011462p5011474.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users