[postgis-users] Upgrade both Postgres/postgis and Debian major releases - how to?

[Andrea Peri]

Perhaps some grant rule change between 9.4 and 9.6 that give unseeable the
spatialrefsys to other tables ?

A.

Il 16 Ago 2017 09:47, "Pietro Rossin" <pietro.rossin at arpa.fvg.it> ha
scritto:

Hello
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

and restore
perl some_path_to/postgis_restore.pl "/somepath/olddb.backup" | psql newdb
2> /tmp/errors.txt

The restore process came to the end and in errors.txt we find many errors
like:

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
srid errors?

Thanks again
Pietro



--
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.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170816/8c553d95/attachment.html>