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

2012-06-13 Thread gipsy-king1
I think my postgis is installed because of these three following reasons - but I am not 100% sure. 1) With pgAdmin I created a database. The template I took was the template_postgis 2) When I open the Application Stack Builder an get the list of all possible applications to install - under

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

2012-06-12 Thread gipsy-king1
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 could not execute query: ERROR: relation strasse.netzknotenmodell_etrs89 does not

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

2012-06-12 Thread Tom Lane
gipsy-king1 stue...@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

[GENERAL] import *.backup-file (PostGIS - not mine)

2012-06-11 Thread gipsy-king1
Dear all I have to import and watch/edit data stored in an .backup-file. This is a backup-file, stored by an other firm. My problem is, I am new at Postgres and it is the first time I have to work with PostGIS-data. I installed pgAdminIII and tryed to import it with this program. But it will not

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

2012-06-11 Thread Alban Hertroys
On 11 June 2012 10:42, gipsy-king1 stue...@gis-consult.de wrote: I have to import and watch/edit data stored in an .backup-file. This is a backup-file, stored by an other firm. Can you tell me what I have to do? Is that a Postgres dump? If so, is it a plain text dump, a compressed dump or a

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

2012-06-11 Thread Stefan Tzeggai
Am 11.06.2012 14:43, schrieb Alban Hertroys: On 11 June 2012 10:42, gipsy-king1 stue...@gis-consult.de wrote: I have to import and watch/edit data stored in an .backup-file. This is a backup-file, stored by an other firm. Can you tell me what I have to do? Is that a Postgres dump? If so, is