I am coming in a little late, but when I did an upgrade, I had to run my dump through one of the postgis update scripts in the contrib directory. Did you do that?
Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James David Smith Sent: Tuesday, August 06, 2013 12:54 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Problems installing on Linux On 6 August 2013 15:38, Rémi Cura <[email protected]> wrote: > Hello, > I had trouble with geos. > Strangely, I had to turn postgres down, then make clean in geos, then > build and install, then clean postgis, then build and install, then > restart postgres. > I had error if not stopping my (local) server, and if not cleaning > geos and postgis before building > > Cheers, > > Rémi-C > > > 2013/8/6 Mike Toews <[email protected]> >> >> On 6 August 2013 22:49, James David Smith >> <[email protected]> >> wrote: >> > >> > Hi Mike, >> > >> > Thanks for the reply. I thought that I had the latest version of >> > GEOS, so I just did 'locate geos' and it found quite a few files. >> > They seem to be grouped into the below folders: >> > >> > /depot/shared/geos-3.0.3/ >> > /depot/shared/geos-3.3.5/ >> > /opt/geos-3.3.8/include/geos/ >> > /depot/shared/pgrouting/geos-3.0.0/ >> > /depot/shared/pgrouting/geos-3.3.5/ >> > /opt/Geos/ >> > >> > I guess that this is causing the problem. >> > >> > Though when I do the "./configure" command for PostGIS I have been >> > pointing the it towards: >> > >> > /opt/geos-3.3.8/bin/geos-config >> > >> > Which should make it use the latest version of GEOS no? >> > >> > Sorry for not being very technical, I'm slowly getting the hang of >> > linux... >> > >> > Thanks >> > >> > James >> >> Technical is always good here. Sometimes it is necessary to update >> the shared library cache by running "ldconfig" after various "make >> install" commands. It might need to be run as root (or with sudo, if >> you have that). >> >> Also, sometimes, it could be also necessary to either add the LIBDIR >> to /etc/ld.so.conf, or add a .conf file in /etc/ld.so.conf.d/, or to >> fiddle around with the LD_LIBRARY_PATH environment variable to point >> to the directory with the current versions of .so shared libraries. >> After any changes with these, run "ldconfig" to update the system >> cache. Yet another good tool is "ldd" to see which libraries are >> being loaded. For example: >> >> $ ldd /usr/pgsql-9.0/lib/postgis-2.0.so >> >> should show you which other .so objects are being referenced. >> >> -Mike >> _______________________________________________ Hi Mike/Remy/all, Thanks for your help. I'm making progress. Please see below. My install is now using geos-3.3.8. Or seems to be. ldd /usr/pgsql-9.0/lib/postgis-2.0.so linux-vdso.so.1 => (0x00007fff735fc000) libgeos_c.so.1 => /opt/Geos/lib/libgeos_c.so.1 (0x00002b4411d4d000) libproj.so.0 => /opt/Proj/lib/libproj.so.0 (0x00002b4411f74000) libjson.so.0 => /opt/json/lib/libjson.so.0 (0x00002b44121ca000) libxml2.so.2 => /opt/LibXml/lib/libxml2.so.2 (0x00002b44123cb000) libz.so.1 => /usr/lib64/libz.so.1 (0x00002b441270e000) libm.so.6 => /lib64/libm.so.6 (0x00002b4412922000) libc.so.6 => /lib64/libc.so.6 (0x00002b4412ba5000) libgeos-3.3.8.so => /opt/Geos/lib/libgeos-3.3.8.so libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002b44132ab000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b44135ab000) libjson-c.so.2 => /opt/json/lib/libjson-c.so.2 (0x00002b44137ba000) libdl.so.2 => /lib64/libdl.so.2 (0x00002b44139c3000) /lib64/ld-linux-x86-64.so.2 (0x0000003f53000000) The following commands now seem to work: psql -d yourdatabase -f postgis.sql psql -d yourdatabase -f postgis_comments.sql psql -d yourdatabase -f spatial_ref_sys.sql And when I go into my database and do SELECT postgis_full_version I get the following: POSTGIS="2.0.4SVN r11660" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" LIBJSON="UNKNOWN" TOPOLOGY However it says that Topology and Raster support are not present. So I thought that I could now run the following commands to install those too: psql -d yourdatabase -f rtpostgis.sql psql -d yourdatabase -f raster_comments.sql psql -d yourdatabase -f topology/topology.sql psql -d yourdatabase -f doc/topology_comments.sql However when I run them I get an error. The first line is: psql:/usr/pgsql-9.0/share/contrib/postgis-2.0/rtpostgis.sql:48: ERROR: could not load library "/usr/pgsql-9.0/lib/rtpostgis-2.0.so": libgeos-3.2.0.so: cannot open shared object file: No such file or directory Any idea why there is still mention of libgeos-3.2.0 ? I thought I'd sorted that out now? Thanks James _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
