[postgis-users] PostGIS + pgdump

[Sandro Santilli]

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;