[postgis-users] ERROR: type "postgis.geometry" is only a shell

[Stefan Schwarzer]

Hi,

I installed postgres & postgis (with Kyngchaos packages). Dumped the  
database from the server:

	pg_dump -i -h <ip_address> -p 5432 -U postgres -F c -v -f dump.c.sql  
<database>

and then re-stored:

	pg_restore -i -U postgres -d <database> -v dump.c.sql

But when it comes to the PostGIS data tables (like country  
boundaries), I get this error message:

	pg_restore: creating TABLE admin01
	pg_restore: [archiver (db)] Error from TOC entry 6472; 1259 3178500  
TABLE admin01 ss_admin
	pg_restore: [archiver (db)] could not execute query: ERROR:  type  
"postgis.geometry" is only a shell
	LINE 8:     the_geom postgis.geometry,
	                     ^
	    Command was: CREATE TABLE admin01 (
	    gid integer NOT NULL,
	    cntry_name character varying(42),
	    cntry_code character varying(13),...
	pg_restore: [archiver (db)] could not execute query: ERROR:  relation  
"gis.admin01" does not exist
	    Command was: ALTER TABLE gis.admin01 OWNER TO ss_admin;


What is this? What can I do?

Thanks for any hints,

Stef