[postgis-users] restoring database without restoring functions

[Markus Schaber]

Hi, Toni,

toni hernnadez wrote:

> Is there any option when backing up a database if I don't want to import
> database functions when restoring?

Use one of the non-text formats for pg_dump, and then the
postgis_restore.pl tool for replay into an Database that has 1.1 installed.

> What I am trying to do is to update a database from postgis version 1.0
> to version 1.1.

You can also update from 1.0 to 1.1 "in place", using lwpostgis_upgrade.sql

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org