Hi Nathan,<br><br>We were not able to reproduce the issue with latest
version of Postgis. Can you please update your Postgis version using
stack builder. Following command should return version as 1.4.1-2.<br><span dir="ltr"><br>
cat /etc/postgres-reg.ini | grep -A 4 PostGIS_PG84 | grep Version | cut -d'=' -f2<br><br>Thanks,<br><font color="#888888">Dharmendra Goyal</font></span><br><br><div class="gmail_quote"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<span dir="ltr"><font color="#888888"><br></font></span><div><div></div><div class="h5"><br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
<br>
-------- Original Message --------
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Subject: </th>
<td>[postgis-users] Can't find <a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a>?</td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Date: </th>
<td>Mon, 23 Aug 2010 18:16:55 -0400</td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">From: </th>
<td>Nathan Odgers <a href="mailto:n.p.odgers@gmail.com" target="_blank"><n.p.odgers@gmail.com></a></td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">Reply-To: </th>
<td>PostGIS Users Discussion
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank"><postgis-users@postgis.refractions.net></a></td>
</tr>
<tr>
<th nowrap valign="BASELINE" align="RIGHT">To: </th>
<td><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a></td>
</tr>
</tbody>
</table>
<br>
<br>
All,<br>
<br>
Disclaimer: I am new to PostgreSQL/PostGIS and am trying to make sense
of it all, so I ask for your patience.<br>
<br>
I downloaded a copy of Postgre Plus Standard Server 8.4 from <a href="http://enterprisedb.com" target="_blank">enterprisedb.com</a>.
It is packaged with PostGIS 1.4. I am running OS X 10.5.8.<br>
<br>
I was working through the basic PostGIS tutorial that enterprisedb
provides using pgAdmin3 entering SQL/pql code through the Terminal
window. This is the demonstration code included in their tutorial, up
to the point at which I am getting stuck.<br>
<br>
CREATE ROLE gisadmin PASSWORD 'mypassword'<br>
<div style="margin-left: 40px;">LOGIN SUPERUSER<br>
</div>
<div style="margin-left: 40px;">INHERIT CREATEDB;<br>
</div>
<br>
CREATE DATABASE roadmaps<br>
<div style="margin-left: 40px;">WITH OWNER = gisadmin<br>
TEMPLATE = template_postgis;<br>
</div>
<br>
\c roadmaps gisadmin;<br>
<br>
CREATE TABLE roads (id INT4, name VARCHAR(128));<br>
<br>
SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY', 2);<br>
<br>
INSERT INTO roads (id, geom, name)<br>
<div style="margin-left: 40px;">VALUES (1, GeomFromText('LINESTRING(0
10,0 0)', -1), 'Beacon Road');<br>
</div>
<br>
Everything seems to work fine until I enter the INSERT statement, after
which I get this error:<br>
<br>
ERROR: could not load library "/Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a>":
dlopen(/Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a>, 10): Library not
loaded:
/Users/buildfarm/pginstaller/PostGIS/caching/osx/proj-4.6.1.osx/lib/libproj.0.dylib<br>
Referenced from: /Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a><br>
Reason: image not found<br>
CONTEXT: SQL function "geomfromtext" statement 1
<div><br>
</div>
<div>I decided to try and inspect the PostGIS settings and see if I
could see what was wrong. However, when I connect to the
template_postgis database and enter select postgis_full_version(), I
get a similar error:</div>
<div><br>
</div>
<div>
<div>ERROR: could not load library "/Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a>":
dlopen(/Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a>, 10): Library not
loaded:
/Users/buildfarm/pginstaller/PostGIS/caching/osx/proj-4.6.1.osx/lib/libproj.0.dylib</div>
<div> Referenced from: /Library/PostgresPlus/8.4SS/lib/<a href="http://postgis-1.4.so" target="_blank">postgis-1.4.so</a></div>
<div> Reason: image not found</div>
<div>CONTEXT: SQL statement "SELECT postgis_lib_version()"</div>
<div>PL/pgSQL function "postgis_full_version" line 11 at SQL statement</div>
<div><br>
</div>
<div>Can anyone help me with this problem?</div>
<div><br>
Regards,<br>
<br>
Nathan</div>
</div>
</div>
</blockquote></div><br><br clear="all"><br></div></div><div><div></div><div class="h5">-- <br>Dharmendra Goyal<br>Senior Software Engineer<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br><br>Phone: +91-20-30589493<br>
Mobile: +91-9552103323<br><br>
Website: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/" target="_blank">http://blogs.enterprisedb.com/</a><br>Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb" target="_blank">http://www.twitter.com/enterprisedb</a><br>
<br>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Dharmendra Goyal<br>Senior Software Engineer<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br><br>Phone: +91-20-30589493<br>Mobile: +91-9552103323<br>
<br>Website: <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/">http://blogs.enterprisedb.com/</a><br>Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb">http://www.twitter.com/enterprisedb</a><br>
<br>This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.<br>
<br>