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

[Jan Hartmann]

  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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users