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

Details

Description:
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

https://git.archlinux.org/svntogit/packages.git/tree/trunk/PKGBUILD?h=packages/postgresql-old-upgrade#n50
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.

Loading...