On Mon, May 20, 2019 at 07:16:15AM +0000, Zwettler Markus (OIZ) wrote: > We tried to pg_restore this dump into a database with and without pre-created > postgis extension. We got postgis errors in any case.
Check out postgis_restore.pl, to be used in place of pg_restore. Is part of the postgis source, not sure if it is distributed with binary packages. The script was meant specifically to deal with these situations. Read more about its usage here: https://postgis.net/docs/postgis_installation.html#hard_upgrade It needs a "custom format" dump, so if your external source did not provide you with one you're out of luck. --strk; () Free GIS & Flash consultant/developer /\ https://strk.kbt.io/services.html _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users