Package Details: postgis-old-upgrade 3.3.2-1

Git Clone URL: (read-only, click to copy)
Package Base: postgis-old-upgrade
Description: PostGIS build against postgresql-old-upgrade package for pg_upgrade
Upstream URL:
Licenses: GPL
Submitter: amdg
Maintainer: grawlinson
Last Packager: grawlinson
Votes: 4
Popularity: 0.37
First Submitted: 2018-12-17 20:08 (UTC)
Last Updated: 2023-01-29 23:17 (UTC)

Latest Comments

bostonvaulter commented on 2022-04-23 17:55 (UTC)

I was able to upgrade today just by changing pg_majorver=12 to pg_majorver=13

c-reeder commented on 2021-04-02 19:24 (UTC)

@blueyed, Thanks! You're my hero of the day!

blueyed commented on 2021-01-19 17:12 (UTC)

The following patched worked for me:

 PKGBUILD | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git i/PKGBUILD w/PKGBUILD
index 0ca9c13..ef6e9bd 100644
@@ -4,9 +4,9 @@
 # Contributor: William Rea <>

 pkgdesc="Postgis build against postgresql-old-upgrade package for pg_upgrade"
@@ -15,7 +15,7 @@ depends=('postgresql-old-upgrade' 'gdal' 'json-c' 'proj' 'protobuf-c')

 build() {
   cd ${pkgname/-old-upgrade/}-${pkgver}

RadioGnome1971 commented on 2020-12-19 18:56 (UTC)

I was able to build it or the 12 -> 13 upgrade by simply changing the parameter 'pg_majorver' to '12' in PKGBUILD.

Only I needed not-mentioned dependencies - clang - distcc - llvm and something which was installed as dependency for clang, and I forgot to note down..

mat commented on 2020-12-10 15:57 (UTC)

With postgresql moving from 12 to 13, this needs a few updates.

jreniel commented on 2020-03-24 13:54 (UTC) (edited on 2020-03-24 15:07 (UTC) by jreniel)

I agree with @bobpaul ... It would be very useful if this package would also include the postgis compiled against the newer postgresql version, because it seem to be required for migration. I'm never again using Arch for a Postgresql db as every upgrade breaks everything.

bobpaul commented on 2020-03-04 22:24 (UTC) (edited on 2020-03-04 22:24 (UTC) by bobpaul)

So in order to upgrade from Postgresql 11 to 12, I had to install both this package AND manually build postgis 2.5 against postgres 12 (and install those *.so files into /usr/lib/postgresql). After running the upgrade, I had to run the command to upgrade my databases to postgis 3 and then I could delete the postgis-2.5 compiled against postgresql 12. (instructions are mostly in this ticket:

It would be really convenient if this package provided both postgis-old for postgres-old (installed into /opt) as well as postgis-old for the current version of postgres (installed into /usr).

Does that make sense and seem reasonable?

geosam commented on 2019-12-12 17:24 (UTC)