[postgis-users] Restore a raster dump from PostGIS 2.1.0 to PostGIS 2.3.0

[ced]

Hi all, 

I am upgrading PostgreSQL and PostGIS from 9.3/2.1 to 9.5/2.3.

I perform the backup on the old server (9.3/2.1) like this using pg_dump.

Then, on the new server (9.5/2.3), I restore the backup using pg_restore.

Everything is correctly restored, except just one raster table, a DEM, which
produces the following error message (sorry, it is in french...):
 
COPY échoué pour la table « mnt » : ERREUR:  l'opérateur n'existe pas :
public.geometry @ public.geometry
LIGNE 1 : SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)
                    ^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types
d'arguments.
Vous devez ajouter des conversions explicites de type.
REQUÊTE : SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)
CONTEXTE : fonction SQL « st_coveredby » durant « inlining »
COPY mnt, ligne 1 : « 1
0100000100000000000000394000000000000039C000000000B76B29410000002035325941000000000000000000000000...
»

The new table is finally empty.
The problem seems to come from a cast problem in _ST_CoveredBy function in
PostGIS 2.3.
Has it changed between 2.1 and 2.3?

How can I restore data?

Thanks in advance for your help.

Regards,
Cedric



--
View this message in context: http://postgis.17.x6.nabble.com/Restore-a-raster-dump-from-PostGIS-2-1-0-to-PostGIS-2-3-0-tp5010627.html
Sent from the PostGIS - User mailing list archive at Nabble.com.