Hi Luís, you may need to do first a "backup globals" of the entire database cluster A. (to import users, etc..)
A good practice (I think) is to avoid public schema for data... Then, for option B, you can backup only data schemas (and use postgis function to populate geometry_columns at the end) Fred. 2010/8/4 Luís de Sousa <luis.a.de.so...@gmail.com> > 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
