[postgis-devel] postgis_restore.pl

[strk]

On Tue, Aug 03, 2004 at 10:04:46AM +0200, strk wrote:
> Hi all,
> I've been working on a postgis restore script.
> Basically the script extracts the ToC from a dump
> and skips all objects that will be defined by postgis.sql.
> Then enables postgis, then restores the dump.
> 
> Under the directory utils/ you can find an initial
> implementation.
> 
> Known issues:
> 
> 	- operators in the dump are always skipped
> 	  because from the ToC there's no way to tell
> 	  wheter or not they belong to postgis.
> 
> 	- It seems that when creating tables in schema 'MySchema'
> 	  pg_restore sets the search path to 'MyScheme', 'pg_catalogue'.
> 	  This means that postgis constraints will invoke functions
> 	  unfindable (geometrytype and srid) w/out the 'public' suffix,
> 	  which is not added :! Any test with this is appreciated.

I've bypassed the second issue always adding 'public' at the end.
I've succeeded in restoring a dump from pgsql 7.3 to pgsql 7.4.

--strk;

> 
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel