[postgis-devel] postgis_restore.pl

strk strk at keybit.net
Tue Aug 3 01:04:46 PDT 2004


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.

--strk;



More information about the postgis-devel mailing list