<div>Hi there</div><div><br></div>pramsey solved this for me on irc: <div><br></div><div>I had installed and then removed postgresql 8.3 via apt previously - but some of it was still hanging about, to wit:</div><div><span class="Apple-style-span" style="font-size: 13px; border-collapse: collapse; "><font class="Apple-style-span" face="'courier new', monospace">[120310 16:52:30] <pramsey> the problem is you have a system pg_config in /usr/bin, but I imagine the postgresql you are running is the one from /usr/local/pgsql</font></span></div>
<div><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse"><div><font class="Apple-style-span" face="'courier new', monospace">[120310 16:53:04] <pramsey> export PATH=/usr/local/pgsql/bin:$PATH and the reconfigure, rebuild, reinstall your postgis</font></div>
<div><br></div><div>This did the trick </div><div><br></div><div>Thanks anyway, </div><div>and kind regards from Iceland,</div><div>Gissur</div></span><br><div class="gmail_quote">On Fri, Mar 12, 2010 at 7:13 PM, Jorge Arevalo <span dir="ltr"><<a href="mailto:jorgearevalo@gis4free.org" target="_blank">jorgearevalo@gis4free.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">2010/3/12 Gissur Þórhallsson <<a href="mailto:gissur@loftmyndir.is" target="_blank">gissur@loftmyndir.is</a>>:<br>
<div><div></div><div>> Hi,<br>
> I'm setting up postgis on a Ubuntu 8.0.4 LTS Server that I'm setting up.<br>
> I decided that it would be best for me build Postgis 1.5 from source so<br>
> that's what I did - starting with Postgres 8.4.2 from trunk through GEOS and<br>
> PROJ and everything went fine. I've now also compiled postgis 1.5 and was<br>
> preparing to run <a href="http://new_postgis_restore.pl" target="_blank">new_postgis_restore.pl</a> to restore my database (migrated<br>
> from windows postgresql 8.2).<br>
> When I try to run psql postgis.sql on the database I intend to restore into<br>
> (as stipulated inside <a href="http://new_postgis_restore.pl" target="_blank">new_postgis_restore.pl</a>) I get the<br>
> following: <a href="http://postgis.pastebin.com/TCC0yk35" target="_blank">http://postgis.pastebin.com/TCC0yk35</a><br>
> Running $ldd /absolute/path/to/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a> returns<br>
> this: <a href="http://postgis.pastebin.com/yERz1HeY" target="_blank">http://postgis.pastebin.com/yERz1HeY</a> (which looks normal enough)<br>
><br>
> For further reference I enclose my pg_config<br>
> output: <a href="http://postgis.pastebin.com/6u3zfTyc" target="_blank">http://postgis.pastebin.com/6u3zfTyc</a><br>
> LIBDIR is set to /usr/lib in there, and my <a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a> is located<br>
> at /usr/lib/postgresql/8.4/lib/ <a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a><br>
> Does anybody have any ideas?<br>
> Kind regards from Iceland,<br>
> Gissur Þórhallsson<br>
><br>
> Loftmyndir ehf.<br>
> Laugavegur 13<br>
> IS 101 Reykjavík - Iceland<br>
> sími (tel): (+354) 540 2500<br>
> tölvupóstur (email): <a href="mailto:gissur@loftmyndir.is" target="_blank">gissur@loftmyndir.is</a><br>
><br>
<br>
</div></div>Hi,<br>
<br>
Try adding /usr/lib/postgresql/8.4/lib/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a> to<br>
/etc/ld.so.conf and then executing "sudo ldconfig"<br>
<br>
Hope this helps...<br>
<br>
Best regards,<br>
Jorge<br>
<br>
<br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Gissur Þórhallsson<br><br>Loftmyndir ehf.<br>Laugavegur 13<br>IS 101 Reykjavík - Iceland<br>sími (tel): (+354) 540 2500<br>tölvupóstur (email): <a href="mailto:gissur@loftmyndir.is" target="_blank">gissur@loftmyndir.is</a><br>
</div>