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

[Fred Lehodey]

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.sousa at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100804/56d8ca85/attachment.html>