Hi,<br><br>Unfortunately after running a /sbin/ldconfig i am still left with the same error. When installing postgis to a "virgin" db, it manages to create the histogram2d datatype like so:<br><br>NOTICE: type "histogram2d" is not yet defined
<br>DETAIL: Creating a shell type definition.<br><br>and then gets the same error<br><br>Cheers,<br><br>Andy<br><br><div><span class="gmail_quote">On 04/06/07, <b class="gmail_sendername">Rob Agar</b> <<a href="mailto:robagar@westnet.com.au">
robagar@westnet.com.au</a>> wrote:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
I think I had this same problem - if it was the same one, running<br>ldconfig to rebuild the shared object cache fixed it.<br><br>ht (might) h<br>Rob<br><br><br>Andy Dale wrote:<br>> After installing proj, the contents under /usr/local/lib are
<br>><br>> -rw-r--r-- 1 root root 1300710 Jun 4 12:05 libproj.a<br>> -rwxr-xr-x 1 root root 796 Jun 4 12:05 <a href="http://libproj.la">libproj.la</a> <<a href="http://libproj.la">http://libproj.la</a>>
<br>> lrwxrwxrwx 1 root root 16 Jun 4 12:05 libproj.so -> libproj.so.0.5.2<br>> lrwxrwxrwx 1 root root 16 Jun 4 12:05 libproj.so.0 -> libproj.so.0.5.2<br>> -rwxr-xr-x 1 root root 758060 Jun 4 12:05 libproj.so.0.5.2
<br>><br>> Postgis recompiled fine after the installation of proj, it even auto<br>> found the proj on the system. The problem comes when i try and run the<br>> sql script to upgrade postgis<br>><br>> Cheers,
<br>><br>> Andy<br>><br>><br>> On 04/06/07, *jrom* <<a href="mailto:jerome.gasperi@gmail.com">jerome.gasperi@gmail.com</a><br>> <mailto:<a href="mailto:jerome.gasperi@gmail.com">jerome.gasperi@gmail.com
</a>>> wrote:<br>><br>> Hi Andy,<br>><br>> After ./configure did you recompile postgis without any problem ?<br>> If the compilation ran well then you should check under /usr/local/lib<br>
> if you have libproj.so.0 file that should be a link to the current<br>> libproj.<br>><br>> For example a typical proj 5 installation you should have something<br>> like this under /usr/local/lib :
<br>> lrwxrwxrwx 1 gass gass 16 2005-09-13 14:47 libproj.so -><br>> libproj.so.0.5.0<br>> lrwxrwxrwx 1 gass gass 16 2005-09-13 14:47 libproj.so.0 -><br>> libproj.so.0.5.0<br>> -rwxr-xr-x 1 gass gass 657462 2005-09-13 14:47
libproj.so.0.5.0<br>><br>> As you can see libproj.so.0 is a dynamic link to libproj.so.0.5.0.<br>> If this link is not present you can create it<br>><br>> Hope this help<br>><br>> On 6/4/07, Andy Dale <
<a href="mailto:andy.dale@gmail.com">andy.dale@gmail.com</a><br>> <mailto:<a href="mailto:andy.dale@gmail.com">andy.dale@gmail.com</a>>> wrote:<br>> > Hi,<br>> ><br>> > I managed to install and use Postgis without any problems,
<br>> > but later found out that i could not do any<br>> > reprojections without the proj library.<br>> ><br>> > I downloaded and installed the proj library. I then<br>> > attempted to re-install Postgis with proj
<br>> > support like so:<br>> ><br>> > ./configure --with-proj=yes (without specifying this flag it<br>> still find the<br>> > proj library) It produces the following output:
<br>> ><br>> > SUMMARY<br>> > -------------------------------------------------------<br>> ><br>> > HOST_OS: linux-gnu<br>> ><br>> > PGSQL: /usr/bin/pg_config
<br>> > PROJ: prefix=/usr/local libdir=/usr/local/lib<br>> > ICONV: 1<br>> ><br>> > PORTNAME: linux<br>> > PREFIX: /usr<br>> > EPREFIX: ${prefix}<br>> > DOC: /usr/share/doc/postgresql/contrib
<br>> > DATA: ${datarootdir}<br>> > MAN: ${datarootdir}/man<br>> > BIN: /usr/bin<br>> > EXT: /usr/lib/pgsql (\$$libdir)<br>> > -------------------------------------------------------
<br>> ><br>> > Now when i try to run either the lwpostgis_upgrade.sql or<br>> lwpostgis.sql<br>> > (creates histogram2d then fails) i get the following error<br>> ><br>> > ERROR: could not load library
<br>> > "/usr/lib/pgsql/liblwgeom.so.1.2": libproj.so.0: cannot<br>> > open shared object file: No such file or directory<br>> ><br>> > Can anyone tell me where i have gone wrong in the installation ??
<br>> ><br>> > Thanks in advance,<br>> ><br>> > Andy<br>> ><br>> ><br>> ><br>> ><br>> ><br>> > _______________________________________________
<br>> > postgis-users mailing list<br>> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<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>> ><br>
> ><br>><br>><br>> --<br>> J.<br>> <a href="http://geogurus.org/jrom">http://geogurus.org/jrom</a><br>> _______________________________________________<br>> postgis-users mailing list
<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <mailto:<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>> <<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a>><br>><br>><br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________
<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><br>_______________________________________________<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></div><br>