Bug 872710

Summary: PostGIS needs to be updated and recompiled for PostgreSQL 9.2
Product: [Fedora] Fedora Reporter: Jeffrey C. Ollie <jeff>
Component: postgisAssignee: Devrim Gündüz <devrim>
Status: CLOSED WONTFIX QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 18CC: blr, cskeogh, dag, devrim, gregory, jr.morreale, juanluisrp, timosha, tuanta
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-02-05 23:22:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Don't install shp2pgsql and shp2pgsql-gui manually, let "make install" take care of it none

Description Jeffrey C. Ollie 2012-11-02 19:22:49 UTC
The current version of PostGIS in Fedora 18 has two problems.  One, PostgreSQL 9.2 is case-sensitive when specifying the language of a function, getting errors like this:

psql:/usr/share/pgsql/contrib/postgis-64.sql:59: ERROR:  language "C" does not exist

If you change "LANGUAGE 'C'" to "LANGUAGE 'c'" in the SQL file you then get these errors:

psql:/usr/share/pgsql/contrib/postgis-64.sql:59: ERROR:  incompatible library "/usr/lib64/pgsql/postgis-1.5.so": version mismatch
DETAIL:  Server is version 9.2, library is version 9.1.

Updating to PostGIS 2.0.1 should take care of both of these problems...

Comment 1 Devrim Gündüz 2012-11-13 15:45:56 UTC
FYI, I started looking at this. Along with PostGIS update, I'm working on a GeOS update.

Comment 2 Jean-Roc Morreale 2013-01-09 09:29:35 UTC
Hi Devrim, do you think this update will be made on time for the release of fedora 18 ? The version mismatch is still present.

Comment 3 Devrim Gündüz 2013-01-15 01:51:25 UTC
:( Well, geos builds were a bit problematic. Looking again.

Comment 4 Truong Anh Tuan 2013-01-18 03:23:36 UTC
Any updates on this?
The issue has been still available in Fedora 18 GA.

Comment 5 Fedora Update System 2013-01-25 21:49:15 UTC
player-3.0.2-24.fc18,gdal-1.9.1-15.fc18.1,grass-6.4.2-5.fc18,geos-3.3.7-1.fc18,postgis-2.0.2-2.fc18 has been submitted as an update for Fedora 18.
https://admin.fedoraproject.org/updates/player-3.0.2-24.fc18,gdal-1.9.1-15.fc18.1,grass-6.4.2-5.fc18,geos-3.3.7-1.fc18,postgis-2.0.2-2.fc18

Comment 6 Devrim Gündüz 2013-01-25 21:50:46 UTC
I used this opportunity to upgrade geos to 3.3.7, too.

Comment 7 Timon 2013-03-06 06:19:13 UTC
still can't use postgis in F18 :(

Comment 8 Devrim Gündüz 2013-03-27 21:02:39 UTC
Now giving another try on new builds...

Comment 9 Fedora Update System 2013-03-27 21:48:05 UTC
postgis-2.0.3-1.fc18,osm2pgsql-0.70.5-0.11.20121021svn.fc18,python-basemap-1.0.6-2.fc18,gdal-1.9.1-16.fc18.1,player-3.0.2-25.fc18 has been submitted as an update for Fedora 18.
https://admin.fedoraproject.org/updates/postgis-2.0.3-1.fc18,osm2pgsql-0.70.5-0.11.20121021svn.fc18,python-basemap-1.0.6-2.fc18,gdal-1.9.1-16.fc18.1,player-3.0.2-25.fc18

Comment 10 Jeffrey C. Ollie 2013-04-01 16:35:37 UTC
I get the following when trying to run shp2pgsql from postgis-2.0.3-1.fc18:

$ shp2pgsql
mkdir: cannot create directory ‘/usr/bin/.libs’: Permission denied
/usr/bin/shp2pgsql: line 202: cd: /builddir/build/BUILD/postgis-2.0.3/loader: No such file or directory
gcc: error: shpopen.o: No such file or directory
gcc: error: dbfopen.o: No such file or directory
gcc: error: getopt.o: No such file or directory
gcc: error: shpcommon.o: No such file or directory
gcc: error: safileio.o: No such file or directory
gcc: error: shp2pgsql-core.o: No such file or directory
gcc: error: shp2pgsql-cli.o: No such file or directory
gcc: error: ../liblwgeom/.libs/liblwgeom.so: No such file or directoryn

Comment 11 Jeffrey C. Ollie 2013-04-01 17:23:18 UTC
Created attachment 730363 [details]
Don't install shp2pgsql and shp2pgsql-gui manually, let "make install" take care of it

Comment 12 Jeffrey C. Ollie 2013-04-01 17:24:48 UTC
See attached patch, shp2pgsql and shp2pgsql-gui are installed by "make install" now and no longer need to be installed manually, especially since they use libtool now.

Comment 13 Dag Bjerkeli 2013-04-25 06:25:45 UTC
I ran into this problem, and I was able to solve it with the 2.0.3-1 build with the patch from comment 11.

I did not encounter the errors described in comment 10 using that patch.

Comment 14 Barry Roberts 2013-07-25 15:20:45 UTC
I'm getting very similar errors as comment #10 in Fedora 19:
[blr@dalmuti AER2]$ shp2pgsql
/usr/bin/shp2pgsql: line 202: cd: /builddir/build/BUILD/postgis-2.0.3/loader: No such file or directory
gcc: error: shpopen.o: No such file or directory
gcc: error: dbfopen.o: No such file or directory
gcc: error: getopt.o: No such file or directory
gcc: error: shpcommon.o: No such file or directory
gcc: error: safileio.o: No such file or directory
gcc: error: shp2pgsql-core.o: No such file or directory
gcc: error: shp2pgsql-cli.o: No such file or directory
gcc: error: ../liblwgeom/.libs/liblwgeom.so: No such file or directory

I haven't tried the patch yet, are there updated rpms for F19?
postgis-2.0.3-1.fc19.x86_64
postgresql-9.2.4-1.fc19.x86_64
postgresql-devel-9.2.4-1.fc19.x86_64
postgresql-jdbc-9.2.1002-2.fc19.noarch
postgis-utils-2.0.3-1.fc19.x86_64
postgresql-server-9.2.4-1.fc19.x86_64
postgis-docs-2.0.3-1.fc19.x86_64
postgresql-libs-9.2.4-1.fc19.x86_64

Comment 15 Fedora End Of Life 2013-12-21 15:49:45 UTC
This message is a reminder that Fedora 18 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 18. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as WONTFIX if it remains open with a Fedora 
'version' of '18'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version prior to Fedora 18's end of life.

Thank you for reporting this issue and we are sorry that we may not be 
able to fix it before Fedora 18 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora, you are encouraged  change the 'version' to a later Fedora 
version prior to Fedora 18's end of life.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.

Comment 16 Fedora End Of Life 2014-02-05 23:22:59 UTC
Fedora 18 changed to end-of-life (EOL) status on 2014-01-14. Fedora 18 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
bug.

Thank you for reporting this bug and we are sorry it could not be fixed.