Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#26159 - [postgis] needs to be rebuilt for postgres 9.1

Attached to Project: Community Packages
Opened by nackd (Prieto) - Friday, 30 September 2011, 08:40 GMT
Last edited by Jaroslav Lichtblau (Dragonlord) - Wednesday, 26 October 2011, 14:22 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Jaroslav Lichtblau (Dragonlord)
Architecture All
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 8
Private No

Details

Description: Rebuild needed.

Additional info:

Upgraded postgres 9.0.4-4 -> 9.1.1-2

Steps to reproduce:

$ sudo -u postgres pg_upgrade -d /var/lib/postgres-old/data -D /var/lib/postgres/data -b /tmp/usr/bin/ -B /usr/bin
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system oid user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating catalog dump ok
Checking for prepared transactions ok
Checking for presence of required libraries fatal

| Your installation references loadable libraries that are missing
| from the new installation. You can add these libraries to
| the new installation, or remove the functions using them
| from the old installation. A list of the problem libraries
| is in the file
| "/tmp/loadable_libraries.txt".

Failure, exiting

$ cat /tmp/loadable_libraries.txt
Failed to load library: $libdir/postgis-1.5
ERROR: no se pudo cargar la biblioteca «/usr/lib/postgresql/postgis-1.5.so»: /usr/lib/postgresql/postgis-1.5.so: undefined symbol: DirectFunctionCall4

Rebuilt postgis and the issue went away.
This task depends upon

Closed by  Jaroslav Lichtblau (Dragonlord)
Wednesday, 26 October 2011, 14:22 GMT
Reason for closing:  Fixed
Additional comments about closing:  Fixed in postgis-1.5.3-2
Comment by Thomas Schreiber (rizumu) - Wednesday, 05 October 2011, 10:44 GMT
I get the same error but on a fresh install, without pg_upgrade. I've first installed postgresql 9.1.1-2, gdal 1.8.0-6, postgis 1.5.3-1 and made my user a postgres superuser. Rebuilding postgis or restarting postgresql doesn't resolve it.

$ initdb -D /usr/local/pgsql/data
$ createdb -E UTF8 template_postgis -T template0
$ createlang -d template_postgis plpgsql
$ psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';" -U postgres
$ psql -d template_postgis -f $(pg_config --sharedir)/contrib/postgis-1.5/postgis.sql -U postgres -v ON_ERROR_STOP=1
SET
BEGIN
psql:/usr/share/postgresql/contrib/postgis-1.5/postgis.sql:59: ERROR: could not load library "/usr/lib/postgresql/postgis-1.5.so": /usr/lib/postgresql/postgis-1.5.so: undefined symbol: DirectFunctionCall4
Comment by Michael Kolomeitsev (mkolomeitsev) - Friday, 07 October 2011, 05:53 GMT
I confirm bug on a fresh install too.

Heh, now postgis cannot be used in Arch 'cause there is no old postgresql-9.0.4 in repository.
Comment by Thomas Schreiber (rizumu) - Friday, 07 October 2011, 08:09 GMT
Yes, for this reason 'cannot be used' I think the severity of this bug could be escalated. For example, I have a non-arch production server with 9.1 and postgis (geodjango). If I do a pg_dump from 9.1 and pg_restore into 9.0 in my development (arch) environment it kinda works, but only with many errors. 9.1 database doesn't downgrade nicely to 9.0 because postgresql has added ``extensions`` feature in 9.1 and the errors in pg_restore are the cause of broken database transactions in Django.

More care could be taken when approving Postgresql version upgrades, to verify that at minimum creating of a ``template_postgis`` database with the postgis extension is functioning, the steps for which are in my first comment.

I have temporaily resolved this by downgrading postgresql and postgresql-libs to 9.0.4.4, but I already had the older version archived locally.
Comment by Hervé (herve) - Friday, 14 October 2011, 09:51 GMT
I ran into this problem and Google found this only link so this is really an Archlinux packaging issue.

Please rebuild postgis, thanks.
Comment by Steve (kwirkie) - Friday, 14 October 2011, 18:35 GMT
As a work around, you can download the PKGBUILD (and postgis.changelog) from http://projects.archlinux.org/svntogit/community.git/tree/trunk?h=packages/postgis and then build the package yourself with 'makepkg'.
Comment by palkeo (palkeo) - Thursday, 20 October 2011, 13:03 GMT
I have the same problem, why is this package not rebuilt ?

Thanks in advance.

Loading...