gipsy-king1 <stuehle@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
