[postgis-users] PostGIS + pgdump

[James Keener]

It'd help if you told us what errors you're getting.

Jim

On Thu, May 16, 2019 at 9:10 AM Zwettler Markus (OIZ) <
Markus.Zwettler at zuerich.ch> wrote:

> Hi,
>
>
>
>
>
> 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.
>
>
>
> We tried to pg_restore the dump into a database without postgis extension
> => postgis errors
>
> We tried to pg_restore the dump into a database with postgis extension =>
> postgis errors
>
> We tried to pg_restore only the public schema into a database with postgis
> extension => postgis errors
>
>
>
> QUESTION:
>
> How does the PostGIS extension have to be installed so that pg_dump +
> pg_restore DO NOT error out?
>
>
>
>
>
> Thanks,
>
> Markus
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190516/b95a191c/attachment.html>