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