<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I 'm trying restore backup from pg11 postgis 2.5.2 to pg12 postgis 3.0.0, but restore failing.
<div><br>
</div>
<div>If I drop postgis 2.5.2 on source server and install 3.0.0 will It cause the problem ?</div>
<div><br>
</div>
<div>details: </div>
<div><br>
</div>
<div>source db (where backup taken):</div>
<div><br>
</div>
<div> PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit</div>
<div> POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL</div>
<div> 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER</div>
<div><br>
</div>
<div>target db (where restore):</div>
<div><br>
</div>
<div> PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit</div>
<div> POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 " SFCGAL="1.3.1" PROJ="6.2.1" LIBXML="2.9.1" LIBJSON="0</div>
<div> .11" LIBPROTOBUF="1.0.2" WAGYU="0.4.3 (Internal)" TOPOLOGY</div>
<div><br>
</div>
<div> dump file:</div>
<div> </div>
<div><br>
</div>
<div> Dump Version: 1.14-0</div>
<div> Format: CUSTOM</div>
<div> Integer: 4 bytes</div>
<div> Offset: 8 bytes</div>
<div> Dumped from database version: 11.1</div>
<div> Dumped by pg_dump version: 12.1</div>
<div><br>
</div>
<div> </div>
<div>example errors:</div>
<div><br>
</div>
<div> pg_restore: error: could not execute query: ERROR: function public.st_accum(public.geometry) does not exist</div>
<div> Command was: GRANT ALL ON FUNCTION public.st_accum(public.geometry) TO test_app;</div>
<div> pg_restore: error: could not execute query: ERROR: type "public.raster" does not exist</div>
Command was: GRANT ALL ON FUNCTION public.st_countagg(public.raster, boolean) TO test_app;<br>
</div>
</body>
</html>