Description of problem: I can't use postgis / postgresql-server after upgrade to rawhide for upcoming Fedora 12, x86_64. Seems like the postgis has not been re-built after updating the postgresql to 8.4.1 Version-Release number of selected component (if applicable): $ rpm -q postgis postgresql postgis-1.3.6-2.fc12.x86_64 postgresql-8.4.1-3.fc12.x86_64 How reproducible: 100% Steps to Reproduce: 1. /sbin/service postgresql initdb 2. su postgres - $ dropdb template_postgis $ createdb -E UTF8 template_postgis # Create the template spatial database. $ createlang -d template_postgis plpgsql # Adding PLPGSQL language support. $ psql -d template_postgis -f $(rpm -ql postgis|grep lwpostgis|grep -v upgrade) Actual results: BEGIN psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:42: NOTICE: type "histogram2d" is not yet defined DETAIL: Creating a shell type definition. psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:42: ERROR: incompatible library "/usr/lib64/pgsql/liblwgeom.so": version mismatch DETAIL: Server is version 8.4, library is version 8.3. psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:48: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:68: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/share/pgsql/contrib/lwpostgis-64.sql:86: ERROR: current transaction is aborted, commands ignored until end of transaction block ... Expected results: lwpostgis-64.sql is processed without errors Additional info: This used to work with postgis and postgresql-server from F11 release
This bug appears to have been reported against 'rawhide' during the Fedora 12 development cycle. Changing version to '12'. More information and reason for this action is here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
Created attachment 372835 [details] fix to allow postgis-1.4.0 rpm to be built The attached patch is sufficient to allow the postgis-1.4.0 fedora CVS package to be built. It loads into a new DB and appears to operate correctly. The postgis_upgrade-64.sql seems to have an issue because it expects the liblwgeom.so shared library to still exist but the new postgis code no longer creates this shared library, perhaps it expects the old postgis-1.3.6 still to be installed in parallel. Alternatively you can rebuild the existing 1.3.6 src rpm to get a working f12 setup as follows: # yum remove postgis # yum-builddep postgis # yumdownloader --source postgis # rpmbuild --rebuild postgis-1.3.6-2.fc12.src.rpm # yum install /root/rpmbuild/RPMS/x86_64/postgis-1.3.6-2.fc12.x86_64.rpm
postgis-1.4.0-3.fc12 has been submitted as an update for Fedora 12. http://admin.fedoraproject.org/updates/postgis-1.4.0-3.fc12
postgis-1.4.0-3.fc12 has been pushed to the Fedora 12 stable repository. If problems still persist, please make note of it in this bug report.