On Thu, May 16, 2019 at 01:09:54PM +0000, Zwettler Markus (OIZ) wrote: > We did a default PostGIS installation within a PostgreSQL 9.6 database: > > === > create extension if not exists postgis; > create extension if not exists postgis_topology; > create extension if not exists ogr_fdw; > create extension if not exists pgrouting; > === > > This installed PostGIS within the public schema of the database. > (SET SCHEMA is not supported since V2.3 anymore) > > Our customer application was also installed within the public schema. > > When we pg_dump + pg_restore the database we got a lot of errors.
At pg_dump or pg_restore time ? What errors did you get ? Do you still have access to the working database ? If so, show us the output of: SELECT postgis_full_version(); --strk; _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
