You could try the newest version of pgadmin, 1.12.0 beta3. It lets you do partial dumps of a database.

Jan

On 08/04/10 13:15, Luís de Sousa wrote:
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to