[postgis-users] Problems installing on Linux

Wilkins, Brian bwilkins at harris.com
Tue Aug 6 11:05:09 PDT 2013


Essentially, yes. See here: http://postgis.net/docs/postgis_installation.html#hard_upgrade

I am not completely clear on your upgrade path, but this is how I did a recent upgrade:


1.      Untarred postgis

2.      Ran configure with --with-geoconfig and --with-projdir set

3.      Moved the old postgis install to new name

4.      Make postgis

5.      Make install DESTDIR=/opt/postgis

6.      Changed ownership of my postgis build directory and share/pgsql directory to postgres:users

7.      Modified the postgis-version/utils/postgis_restore.pl to remove the portion where the database is created

8.      Backed up my existing database

a.      pg_dumpall -h localhost -p 5432 -U <username> -globals-only > globals.sql

b.      pg_dump -d -Fc <database name> > /tmp/<dumpname>.dmp

c.      pg_dump <database name> -t <special table you want to dump - this is optional> > /tmp/<table>.sql (optional - used for testing upon restore)

9.      Login as postgres user

10.   $ psql

11.   postgres=# drop database <database name>;

12.   DROP DATABASE

13.   postgres=# \q

14.   $ psql -U postgres -d postgres -f globals.sql (may not be needed but I did it anyways because I upgraded the DB too)

15.   $ createdb -U <username>

16.   $ createdb -U <username> database

17.   $ createlang -U postgres plpgsql -d database

18.   $ psql -U postgres -f postgis.sql -d database

19.   $ psql -U postgres -f spatial_ref_sys.sql -d database

20.   $ sh share/pgsql/contrib/utils/postgis_restore.pl <upgrade sql script under contrib> <database name> <dump file name> &> restore.log

21.   Finally after examing for any errors:

22.   psql -c 'select postgis_full_version();' -d <database name>

23.   And finally, run some tests. For instance, I had a non-postgis table that I dumped again and diff'd with my original dump. Or you can execute an ST_Extent on a geolocation.. up to you



From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of James David Smith
Sent: Tuesday, August 06, 2013 1:44 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems installing on Linux


Sorry Brian, but I'm not sure what that means. There are a few scripts in the postgis 2 contrib directory. Do I just run them like I've been running the above commands e.g. psql -d yourdatabase -f postgis.sql
On 6 Aug 2013 18:08, "Wilkins, Brian" <bwilkins at harris.com<mailto:bwilkins at harris.com>> wrote:
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: postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> [mailto:postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org>] 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 <remi.cura at gmail.com<mailto:remi.cura at gmail.com>> 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 <mwtoews at gmail.com<mailto:mwtoews at gmail.com>>
>>
>> On 6 August 2013 22:49, James David Smith
>> <james.david.smith at gmail.com<mailto:james.david.smith at gmail.com>>
>> 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<http://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<http://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<http://libgeos-3.3.8.so> => /opt/Geos/lib/libgeos-3.3.8.so<http://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<http://rtpostgis-2.0.so>":
libgeos-3.2.0.so<http://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
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130806/3a322ae1/attachment.html>


More information about the postgis-users mailing list