[postgis-users] GISGRAPHY setup issue

[Ing. Ramon Resendiz]

Hi all,

 

I’ve tried to install the GISGRAPHY to integrated it with OPENGTS, i’ve
successfully installed OPENGTS but when I tried to configure the POSGTIS
database to create the postgis function there is an error, that I couldn’t
found information about it, that why I’m recurring to you.

 

The issues is the following:

 

# create the database

psql -U YOURUSER  -h YOURIP -c  "CREATE DATABASE gisgraphy ENCODING =
'UTF8';" à OK

 

#create language

createlang -U YOURUSER -h YOURIP plpgsql gisgraphy à OK

 

Descripción: Descripción: cid:image001.png at 01CCC6F0.1A2B5580

 

#create postgis function

psql -U USER -h 127.0.0.1 -d gisgraphy -f
/usr/share/pgsql/contrib/postgis-1.5/postgis.sql à ERROR

 

There is some function that create without any problem until the next error
message appear:

 

psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:2024: ERROR:  language
"plpgsql" does not exist

HINT:  Use CREATE LANGUAGE to load the language into the database.

 

Descripción: Descripción: cid:image002.png at 01CCC6F0.1A2B5580

 

Even when i tried to import the file spatial_ref_sys.sql there is an error,
I try to figure out due the postgis.sql could not was imported correctly.

 

 

psql -U USER -h 127.0.0.1 -d gisgraphy -f
/usr/share/postgresql-YOURPOSTGRESVERSION-postgis/spatial_ref_sys.sql

 

 

Best regards,

RR

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120102/f1c565a4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 46327 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120102/f1c565a4/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 101041 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120102/f1c565a4/attachment-0001.png>