[postgis-users] Topology performance test

[Luca Morandini]

On 06/21/2012 10:29 PM, Sandro Santilli wrote:
>>
>> I guess it boils down to this:  I can I get rid of 3.3.3 ?
>
> You can surely get rid of 3.3.3 by running "make uninstall" from its
> build tree, or by manually dropping libgeos_c.so.1.7.3. But you can
> probably also just re-link libgeos_c.so.1  to libgeos_c.so.1.7.4
>
> I'm surprised this isn't done by 'ldconfig' itself (did you run that
> after installing geos ?)

Well, I did
- "make uninstall" in Geos 3.3.3
- ran ldconfig, "make; make install" in Geos 3.3.4
- ran ldconfig again
- run "./configure --withour-raster; make; make install" in postgis
- ran ldconfig again
- restarted PostgreSQL service
- created a database
- ran postgis.sql, spatial_ref_sys.sql, topology.sql on said database

Now ldd gives:
ldd /usr/local/lib/libgeos_c.so
         linux-vdso.so.1 =>  (0x00007fff159ff000)
         libgeos-3.3.4.so => /usr/local/lib/libgeos-3.3.4.so (0x00007fe9cf065000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007fe9ced51000)
         libm.so.6 => /lib/libm.so.6 (0x00007fe9ceacd000)
         libc.so.6 => /lib/libc.so.6 (0x00007fe9ce74a000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007fe9ce533000)
         /lib64/ld-linux-x86-64.so.2 (0x00007fe9cf635000)
ldd /usr/local/lib/libgeos.so
         linux-vdso.so.1 =>  (0x00007fff7b7ff000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007f66e11e6000)
         libm.so.6 => /lib/libm.so.6 (0x00007f66e0f63000)
         libc.so.6 => /lib/libc.so.6 (0x00007f66e0bdf000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007f66e09c8000)
         /lib64/ld-linux-x86-64.so.2 (0x00007f66e18a5000)

...but, still:

select postgis_full_version();
POSTGIS="2.1.0SVN r9949" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 
2009" LIBXML="2.7.6" TOPOLOGY
(1 row)

I am confused a bit :|

Regards,

Luca Morandini
Data Architect - AURIN project
Department of Computing and Information Systems
University of Melbourne
Tel. +61 03 903 58 380
Skype: lmorandini