<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 3.0cm 70.85pt 3.0cm; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
PRE {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Courier New"; FONT-SIZE: 10pt; mso-style-priority: 99; mso-style-link: "HTML con formato previo Car"
}
P.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Texto de globo Car"
}
LI.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Texto de globo Car"
}
DIV.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Texto de globo Car"
}
SPAN.HTMLconformatoprevioCar {
FONT-FAMILY: "Courier New"; mso-fareast-language: ES-MX; mso-style-priority: 99; mso-style-link: "HTML con formato previo"; mso-style-name: "HTML con formato previo Car"
}
SPAN.TextodegloboCar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Texto de globo"; mso-style-name: "Texto de globo Car"
}
SPAN.EstiloCorreo21 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=ES-MX vLink=purple link=blue>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=695273503-03012012>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=695273503-03012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=695273503-03012012>You could try doing using:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=695273503-03012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT size=2 face=Arial><SPAN
class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>psql -U USER -h 127.0.0.1 -d gisgraphy -c "CREATE LANGUAGE
plpgsql;"</SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT size=2 face=Arial><SPAN
class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT size=2 face=Arial><SPAN
class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>In theory you should have same issue but you might get a
different message. </SPAN></SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US></SPAN></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>Which version of PostgreSQL are you using?</SPAN></SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=695273503-03012012><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>You might also try postgresql general as I don't think this is a
PostGIS specific issue.</SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV dir=ltr align=left><SPAN class=695273503-03012012><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=695273503-03012012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=695273503-03012012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=695273503-03012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Ing. Ramon Resendiz<BR><B>Sent:</B> Monday, January 02, 2012 3:38
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] GISGRAPHY setup issue<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN lang=EN-US>Hi all,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>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.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>The issues is the
following:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US># create the database<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>psql -U <I>YOURUSER</I> -h <I>YOURIP</I> -c "CREATE
DATABASE gisgraphy ENCODING = 'UTF8';" </SPAN><SPAN
style="FONT-FAMILY: Wingdings; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>à</SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US> <B><SPAN
style="COLOR: #00b050">OK</SPAN></B><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>#create language<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>createlang -U YOURUSER -h YOURIP plpgsql gisgraphy </SPAN><SPAN
style="FONT-FAMILY: Wingdings; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>à</SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US> <B><SPAN
style="COLOR: #00b050">OK<o:p></o:p></SPAN></B></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="mso-fareast-language: ES-MX"><IMG
id=Imagen_x0020_1
alt="Descripción: Descripción: cid:image001.png@01CCC6F0.1A2B5580"
src="cid:695273503@03012012-19B0" width=955 height=136></SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>#create postgis function<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>psql -U USER -h 127.0.0.1 -d gisgraphy -f
/usr/share/pgsql/contrib/postgis-1.5/postgis.sql </SPAN><SPAN
style="FONT-FAMILY: Wingdings; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>à</SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US> <B><SPAN style="COLOR: red">ERROR<o:p></o:p></SPAN></B></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Courier New'; COLOR: red; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>There is some function that create without any problem until the
next error message appear:<SPAN
style="COLOR: red"><o:p></o:p></SPAN></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Courier New'; COLOR: red; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Courier New'; COLOR: #c00000; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:2024:
ERROR: language "plpgsql" does not exist<o:p></o:p></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Courier New'; COLOR: #c00000; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>HINT: Use CREATE LANGUAGE to load the language into the
database.</SPAN></B><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="mso-fareast-language: ES-MX"><IMG
id=Imagen_x0020_2
alt="Descripción: Descripción: cid:image002.png@01CCC6F0.1A2B5580"
src="cid:695273503@03012012-19B7" width=955 height=680></SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Even when i tried to import the file
</SPAN><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>spatial_ref_sys.sql</SPAN><SPAN lang=EN-US> there is an error, I
try to figure out due the postgis.sql could not was imported
correctly.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-fareast-language: ES-MX"
lang=EN-US>psql -U USER -h 127.0.0.1 -d gisgraphy -f
/usr/share/postgresql-YOURPOSTGRESVERSION-postgis/spatial_ref_sys.sql<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Best regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
lang=EN-US>RR<o:p></o:p></SPAN></P></DIV></BLOCKQUOTE></BODY></HTML>