Arch Linux User Repository

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
 _pkgname="${pkgname%-old-upgrade}"
 pkgver=3.3.2
 pkgrel=2
-_pg_majorver=14
+_pg_majorver=15
 pkgdesc='PostGIS build against postgresql-old-upgrade package for pg_upgrade'
 arch=('x86_64')
 url='https://postgis.net/'
@@ -21,7 +21,7 @@ depends=(
   'pcre'
   'libxml2'
 )
-makedepends=('clang' 'llvm')
+makedepends=('clang15' 'llvm15')
 optdepends=('perl: for scripts in contrib folder')
 options=('!makeflags')
 source=("https://download.osgeo.org/postgis/source/$_pkgname-$pkgver.tar.gz")

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/Makefile.global:1094: 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/pgxs.mk:240: install] Error 127

@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}"
   make

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."
      |  ^~~~~

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

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

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
--- i/PKGBUILD
+++ w/PKGBUILD
@@ -4,9 +4,9 @@
 # Contributor: William Rea <sillywilly@gmail.com>

 pkgname=postgis-old-upgrade
-pkgver=2.5.3
+pkgver=3.0.3
 pkgrel=1
-pg_majorver=11
+pg_majorver=12
 pkgdesc="Postgis build against postgresql-old-upgrade package for pg_upgrade"
 arch=('x86_64')
 url="http://postgis.net/"
@@ -15,7 +15,7 @@ depends=('postgresql-old-upgrade' 'gdal' 'json-c' 'proj' 'protobuf-c')
 changelog=$pkgname.changelog
 options=('!makeflags')
 source=(http://download.osgeo.org/postgis/source/${pkgname/-old-upgrade/}-${pkgver}.tar.gz)
-sha256sums=('72e8269d40f981e22fb2b78d3ff292338e69a4f5166e481a77b015e1d34e559a')
+sha256sums=('07fedbd046cbed55d24bb22474890a4651d0223b6e12d2dac1517b9a43674817')

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

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..

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