[postgis-users] GISGRAPHY setup issue

[Ing. Ramon Resendiz]

Hi Regina,

 

I’ve tried with your syntaxes and the same error still appearing, i’m
attaching a document with the output for the command that I’ve ran
previously.

 

The version that i’m running right now is the following:

 

[root at gtlabserver01 ~]# psql -V

psql (PostgreSQL) 8.4.9

contains support for command-line editing

 

Do you thinks this may have to see with the PostreSQL version that i’m
running?

 

Thank you for your comments.

 

Best regards,

Ramon

 

 

De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] En nombre de Paragon
Corporation
Enviado el: lunes, 02 de enero de 2012 09:41 p.m.
Para: 'PostGIS Users Discussion'
Asunto: Re: [postgis-users] GISGRAPHY setup issue

 

What you have looks right, but perhaps the account you are using to install
postgis.sql doesn't have rights to language or the port it default to is
different.

 

You could try doing using:

 

psql -U USER -h 127.0.0.1 -d gisgraphy -c "CREATE LANGUAGE plpgsql;"

 

In theory you should have same issue but you might get a different message. 

 

Which version of PostgreSQL are you using?

You might also try postgresql general as I don't think this is a PostGIS
specific issue.

 

Hope that helps,

Regina

http://www.postgis.us

 


  _____  


From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ing.
Ramon Resendiz
Sent: Monday, January 02, 2012 3:38 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] GISGRAPHY setup issue

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/20120103/e3648ecf/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/20120103/e3648ecf/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/20120103/e3648ecf/attachment-0001.png>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: gisgraphy-setup-03jan2011.txt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120103/e3648ecf/attachment.txt>