Re: import *.backup-file (PostGIS - not mine)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gipsy-king1 <stuehle(at)gis-consult(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: import *.backup-file (PostGIS - not mine)
Date: 2012-06-12 14:18:11
Message-ID: 16859.1339510691@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

gipsy-king1 <stuehle(at)gis-consult(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Good 2012-06-12 16:33:39 Recovery continually requests new WAL files
Previous Message gipsy-king1 2012-06-12 13:01:34 Function already exists with same argument types