[postgis-users] Backup and Restore of a PostGis database

[Luís de Sousa]

Dear all,

I'm having a hard time porting a postgis database to another server
(let's call server A the one where the original database resides and
server B the one where I need to replicate the database). I'm trying
it in two different ways:

1. Creating a fresh empty database at server B and then restoring.
With this process PostGres complains of not having permissions to
create basic types.

2. Creating a fresh database from the PostGis template. This way
PostGres complains of objects that already exist.

At the root of this is the fact that when dumping a PostGis database,
all PostGis objects are created, functions, types, etc. Is there a way
of making a dump excluding the creation of PostGis objects?

Thank you,

Luís