Re: import *.backup-file (PostGIS - not mine) - Mailing list pgsql-general

From Tom Lane
Subject Re: import *.backup-file (PostGIS - not mine)
Date
Msg-id 16859.1339510691@sss.pgh.pa.us
Whole thread Raw
In response to Re: import *.backup-file (PostGIS - not mine)  (gipsy-king1 <stuehle@gis-consult.de>)
Responses Re: import *.backup-file (PostGIS - not mine)
List pgsql-general
gipsy-king1 <stuehle@gis-consult.de> writes:
> There are few errors after my pg_restore command.
> pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
> "H:.../netzknotenmodell_etrs89.backup"
> could not execute query: ERROR:  type "public.geometry" is only a shell

Are these partial dumps?  It appears that you don't have postgis
installed in the target database, but a full dump should have included
the postgis types and functions.  If they were partial, what you need to
do is install postgis first.

            regards, tom lane

pgsql-general by date:

Previous
From: gipsy-king1
Date:
Subject: Re: import *.backup-file (PostGIS - not mine)
Next
From: gipsy-king1
Date:
Subject: Function already exists with same argument types