Package Details: postgis-old-upgrade 3.3.2-2

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: None
Last Packager: grawlinson
Votes: 7
Popularity: 0.32
First Submitted: 2018-12-17 20:08 (UTC)
Last Updated: 2023-06-02 22:25 (UTC)

Latest Comments

1 2 Next › Last »

AlfredoRamos commented on 2023-12-08 23:29 (UTC) (edited on 2023-12-08 23:44 (UTC) by AlfredoRamos)

To upgrade from PostgreSQL 15 to 16 it seems that this package also needs Clang and LLVM 15.

--- a/PKGBUILD  2023-12-08 17:15:54.341708988 -0600
+++ b/PKGBUILD  2023-12-08 17:24:18.288207226 -0600
@@ -7,7 +7,7 @@ pkgname=postgis-old-upgrade
 pkgdesc='PostGIS build against postgresql-old-upgrade package for pg_upgrade'
@@ -21,7 +21,7 @@ depends=(
-makedepends=('clang' 'llvm')
+makedepends=('clang15' 'llvm15')
 optdepends=('perl: for scripts in contrib folder')

Otherwise you get the following errors:

make[1]: /usr/lib/llvm15/bin/clang: No such file or directory
make[1]: *** [/opt/pgsql-15/lib/pgxs/src/makefiles/../../src/ postgis_module.bc] Error 127
/bin/sh: line 1: /usr/lib/llvm15/bin/llvm-lto: No such file or directory
make[1]: *** [/opt/pgsql-15/lib/pgxs/src/makefiles/ install] Error 127

AchmadFathoni commented on 2023-05-13 00:41 (UTC) (edited on 2023-05-13 00:41 (UTC) by AchmadFathoni)

@kaitocross, You can try this

@@ -32,6 +32,7 @@ build() {
   cd "$_pkgname-$pkgver"

   export PG_CONFIG="/opt/pgsql-${_pg_majorver}/bin/pg_config"
+  export CXXFLAGS="$CXXFLAGS -std=c++17"

   ./configure --prefix="/opt/pgsql-${_pg_majorver}"

kaitocross commented on 2023-04-07 01:42 (UTC) (edited on 2023-04-07 01:43 (UTC) by kaitocross)

It doesnt compile anymore on a recent Arch Linux system. Error:

make[2]: Verzeichnis „/home/username/.cache/yay/postgis-old-upgrade/src/postgis-3.3.2/deps/flatgeobuf“ wird betreten
gcc -std=c++11 -x c++ -I../../liblwgeom -I../../liblwgeom -I./include  -I/usr/include   -I/usr/include/libxml2  -I/usr/include/json-c   -DNDEBUG  -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection -Wp,-D_GLIBCXX_ASSERTIONS  -fPIC -DPIC -c -o flatgeobuf_c.o flatgeobuf_c.cpp
In Datei, eingebunden von /usr/include/absl/base/config.h:86,
                 von /usr/include/absl/base/attributes.h:37,
                 von /usr/include/absl/strings/string_view.h:39,
                 von ./include/flatbuffers/base.h:237,
                 von ./include/flatbuffers/array.h:20,
                 von ./include/flatbuffers/flatbuffers.h:22,
                 von feature_generated.h:7,
                 von flatgeobuf_c.cpp:26:
/usr/include/absl/base/policy_checks.h:79:2: Fehler: #error "C++ versions less than C++14 are not supported."
   79 | #error "C++ versions less than C++14 are not supported."
      |  ^~~~~

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.