FS#43680 - [postgresql-old-upgrade] postgis with postgresq 9.4

Attached to Project: Arch Linux
Opened by abaya (yakoub) - Monday, 02 February 2015, 20:45 GMT
Last edited by Levente Polyak (anthraxx) - Tuesday, 15 May 2018, 20:53 GMT
Task Type Support Request
Category Packages: Extra
Status Closed
Assigned To Dan McGee (toofishes)
Levente Polyak (anthraxx)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No


upgrading from postgres 9.3 to 9.4 and encountered problem with postgis .

could not access file "$libdir/postgis-2.1"

pg_dump: [archiver (db)] query failed: ERROR: incompatible library "/opt/pgsql-9.3/lib/postgis-2.1.so": version mismatch
DETAIL: Server is version 9.3, library is version 9.4.

Steps to reproduce:

pg_upgrade -b /opt/pgsql-9.3/bin/ -B /usr/bin/ -d /var/lib/postgres/data-9.3 -D /var/lib/postgres/data
This task depends upon

Closed by  Levente Polyak (anthraxx)
Tuesday, 15 May 2018, 20:53 GMT
Reason for closing:  Fixed
Additional comments about closing:  9.6.9-1
Comment by Doug Newgard (Scimmia) - Tuesday, 03 February 2015, 03:32 GMT
Did you restart the server? And what is being loaded from /opt? Is this something from the AUR?
Comment by abaya (yakoub) - Tuesday, 03 February 2015, 05:08 GMT
the server was stopped , pg_upgrade doesn't work on a running server .
after pacman -Suy upgrade, /opt only has 9.3 directory and not 9.4
Comment by Doug Newgard (Scimmia) - Tuesday, 03 February 2015, 05:19 GMT
OK, I found the dir, it comes from postgresql-old-upgrade.
Comment by abaya (yakoub) - Tuesday, 03 February 2015, 06:04 GMT
i did install postgresql-old-upgrade, are you saying that package is missing the right directory under /opt ?
command : pacman -S --needed postgresql-old-upgrade
Comment by Dan McGee (toofishes) - Wednesday, 04 February 2015, 13:53 GMT
If you're using extensions, you need to do more work, on your own.

Copy the old *.so file built for 9.3 into the pg-upgrade library directory.

Nothing we as a distro are going to fix here, we're not going to package every extension just for upgrade purposes.
Comment by Sebastián Magrí (sebasmagri) - Sunday, 10 April 2016, 06:08 GMT
Would at least the postgresql headers be included in the postgresql-old-upgrade packages to ease building the old version of the extension?

It's really painful each time you have to upgrade postgis after a major upgrade of postgres.
Comment by KMQ (kmq) - Sunday, 11 December 2016, 22:50 GMT
Having the postgresql headers in place would have come in handy during today's update.

Supplying them is easily done by removing lines 50 and 51 from the PKGBUILD

Comment by Levente Polyak (anthraxx) - Friday, 11 May 2018, 00:57 GMT
I have included the header files into the next build. There won't be any support for this beyond that.