[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-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

[GENERAL] Function already exists with same argument types

2012-06-12 Thread gipsy-king1
Dear all I want to import a postGIS-DB backup-file. When I execute this command: *pg_restore -i -h localhost -p 5432 -U postgres -d THS -v "/alkis.backup" > "\output.txt" 2>&1* I get an textfile with all outputs. There are lots of ERRORs like this: *pg_restore: erstelle FUNCTION st_geometry_an

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 "Spa