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

[pcreso at pcreso.com]

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 <luis.a.de.sousa at gmail.com> wrote:

> From: Luís de Sousa <luis.a.de.sousa at gmail.com>
> Subject: [postgis-users] Backup and Restore of a PostGis database
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>