[postgis-users] archiving postgis table

[Mark Cave-Ayland]

On Tue, 2007-01-09 at 13:39 +0000, David Potts wrote:
> Whats the best way of archving a postgis database.
> 
> I generated a dump with pg_dump.
> 
> I Attempted to reload that in to empty, but postgis enabled database and
> received broadside of errors from postgis. Mainly about attempt to
> redefine existing tables.
> 
> Is it just a case of telling postgres to only dump my tables, instead of
> including all of the postgis support.
> 
> Dave.


Hi Dave,

If both databases are on the same machine, then simply create an empty
database (without explicitly enabling PostGIS) since the dump already
contains the PostGIS definitions.


Kind regards,

Mark.