[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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users