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!
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!
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
Opened by nackd (Prieto) - Friday, 30 September 2011, 08:40 GMT
Last edited by Jaroslav Lichtblau (Dragonlord) - Wednesday, 26 October 2011, 14:22 GMT
|
DetailsDescription: 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
Wednesday, 26 October 2011, 14:22 GMT
Reason for closing: Fixed
Additional comments about closing: Fixed in postgis-1.5.3-2
$ 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
Heh, now postgis cannot be used in Arch 'cause there is no old postgresql-9.0.4 in repository.
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.
Please rebuild postgis, thanks.
Thanks in advance.