Hi Luis, With option 2, all the errors are about a failure to create objects (postgis functions & spatial_ref_sys entries I assume).
Why is this a problem for you? They already exist so do not need to be reinstalled, the rest of your database should be installed, so you should have a fully functional copy. If you ignore the error warnings about trying to reinstall postgis objects, is there a reason the resulting database is not what you wanted to create? Cheers, Brent Wood --- On Wed, 8/4/10, Luís de Sousa <[email protected]> wrote: > From: Luís de Sousa <[email protected]> > Subject: [postgis-users] Backup and Restore of a PostGis database > To: "PostGIS Users Discussion" <[email protected]> > Date: Wednesday, August 4, 2010, 11:15 PM > 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
