<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>hi</FONT></DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<DIV><FONT face=Arial size=2>you need to use psql with '\i'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>example</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>drop mydatabase</FONT></DIV>
<DIV><FONT face=Arial size=2>createdb mydatabase</FONT></DIV>
<DIV><FONT face=Arial size=2>createlang plpgsql mydatabase</FONT></DIV>
<DIV><FONT face=Arial size=2>psql -d mydatabase -c "\i
path_to_postgis.sql/postgis.sql"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>where path_to_postgis.sql is the path to your file
postgis.sql (....)</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=misalda@ixp.net href="mailto:misalda@ixp.net">misalda@ixp.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, October 10, 2004 10:39
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis-users] Help !!
postgis.sql error</DIV>
<DIV><BR></DIV>
<DIV id=divId>
<DIV>im getting the folowing error when trying to run the postgis.sql script
on mi database</DIV>
<DIV> </DIV>
<DIV>cannot fint $libdir/libpostgis.so.0.9</DIV>
<DIV> </DIV>
<DIV>any ideas on how to solve thsi problem? or how can i install this library
file? </DIV></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></BODY></HTML>