PGSTY RPM Package Builder

Extensions Building Scripts for PostgreSQL 13 - 18 on EL 8/9/10

• Pigsty PGSQL Repo
• RPM Change Log

You can build extension RPMs with pig.

curl https://repo.pigsty.cc/pig | bash -s 1.1.0
pig build repo
pig build tool
pig build spec # <--- get this repo, setup building environment
pig build rust
pig build pgrx

# then build packages
pig build pkg timescaledb
pig build pkg pg_search

Native builds keep compiler DWARF and generate the standard main, -debuginfo, and -debugsource RPMs by default. Rust extensions remain optimized release builds while setting Cargo's release debug level to 2 and leaving stripping to RPM. Pure SQL/data/script packages with a genuine BuildArch: noarch payload do not generate empty debug packages. Specs that invoke CMake, Meson, Autoconf, or compilers directly must import RPM build flags so the automatic split has real DWARF to package.

rpmbuild/SPECS/postgis.spec builds PostGIS 3.7.0 for PostgreSQL 14–18 on EL8/EL9/EL10 with postgis37_<major> package names. Raster, SFCGAL, topology, client tools, GUI, utilities, and PDF documentation are retained. LLVM bitcode belongs to the main package. Native payloads retain debuginfo and debugsource packages; the empty upstream devel package is omitted. GDAL's Python tools and Javadoc are noarch; its Java and Python native bindings retain debug packages. The Javadoc patch fixes invalid links and makes generator errors fail the build.

PostGIS 3.7 no longer ships address_standardizer or postgis_tiger_geocoder in the core source tree. They are built independently from their upstream archives as address_standardizer_<major> (3.7.0) and postgis_tiger_geocoder_<major> (2025.2); the Tiger package is limited to PostgreSQL 16–18 and is noarch.

The EL9/EL10 build order is:

1. geos314 3.14.1, proj98 9.8.1, and sfcgal 2.2.0.
2. libgeotiff17 1.7.4 and librttopo 1.1.0, then libspatialite50 5.1.0.
3. gdal313 3.13.3, including the PGDG Python 3.12 and Java bindings.
4. postgis 3.7.0 for the selected PostgreSQL major.
5. address_standardizer 3.7.0 and postgis_tiger_geocoder 2025.2 for the selected PostgreSQL major.

Build and install each library's runtime and development RPMs before building its consumers. On EL9/EL10, system dependencies including CGAL, Boost, and Arrow come from the builder's OS/EPEL repositories. EL8 follows PGDG's compatibility branches: proj96 9.6.2, sfcgal 1.4.1 and gdal38 3.8.5, with locally built cgal54 5.4.2 and ogdi41 4.1.1. Build CGAL before SFCGAL and OGDI before GDAL. ./dep gdal38 18 enables the EL8 module stream providing the utf8proc headers required by EPEL Arrow. The individual Makefile targets for these libraries build once; make postgis builds PostgreSQL 14–18, while ./build postgis 18 selects just PG18.

In a disposable pilot builder, exclude these GIS package families from remote repositories after staging their build inputs, and install the locally built RPMs explicitly. Otherwise dnf builddep can upgrade them back to PGDG's higher release numbers before building the next component. Keep all native debug packages and the normal RPM RPATH checks enabled.

Source provenance records the exact PGDG source RPM URLs and SHA-256 hashes. The source manifest covers the archives and auxiliary inputs stored in src. GDAL deliberately uses PGDG's cleaned gdal-3.13.3-fedora.tar.xz and its provenance notice.

Inside a builder, first run pig build get <package>. If these new package names are not yet available in the source catalog, copy only the missing manifest-listed inputs into the builder's ~/rpmbuild/SOURCES/. Verify the manifest there, then run ./dep <package> 18 and ./build <package> 18. The local checkout's rpmbuild/SOURCES/ must remain empty.

After installing the built RPMs, run bin/postgis-test.sql with psql -f in a disposable database. It creates the four PostGIS 3.7.0 extensions and checks GEOS overlay, PROJ transformation, SFCGAL 3D area, GDAL GeoTIFF export/import, and topology creation. Run bin/postgis-split-test.sql in the same database to check address parsing, US standardization, and, on PG16–18, TIGER address normalization and loader SQL generation. A pilot on one builder does not validate the other platforms or publish any package.

The PostGIS 3.6.4 full build on 2026-10-04 passed on pgsty/el8{,a}:build, pgsty/el9{,a}:build and pgsty/el10{,a}:build: Rocky Linux 8.10, 9.8 and 10.2 on x86_64/aarch64, each with PostgreSQL 14–18. It produced 506 binary RPMs (including 226 debug packages) and 76 SRPMs. PostGIS passed 21,300 SQL regression executions across fresh installation and self-upgrade; RPM-side CUnit tests were not separately run. Installed payloads, native dependencies, GDAL Python/Java bindings, debug packages, LLVM bitcode and multi-version coinstallation were verified. Artifacts and SHA-256 receipts are retained in yum/postgis-full-20261004/; packages were collected locally, not published.

The 2026-11-05 EL8 gap build passed on Rocky Linux 8.10 with pgsty/el8:build (x86_64) and pgsty/el8a:build (aarch64). PostGIS 3.7.0 and address_standardizer 3.7.0 cover PG14–18; TIGER 2025.2 covers PG16–18. PGDG supplies the GIS dependencies: GEOS 3.14.1, PROJ 9.6.2, GDAL 3.8.5, SFCGAL 1.5.2, and libgeotiff 1.7.4. EL8 explicitly supplies GMP flags because its development package has no gmp.pc, and disables LTO through configure; LLVM remains enabled. The standalone address parser no longer requires PostGIS. Each platform directory contains 63 RPMs, including 30 debug packages. The 13 noarch RPMs are shared byte-for-byte, yielding 113 distinct RPMs and 23 SRPMs across both builders. Payloads, DWARF, main-package LLVM bitcode, runtime dependencies, parallel PG installation, and both smoke scripts passed for every supported target. RPMs and SHA-256 manifests are in yum/postgis37-el8-20261105/; logs, source RPMs, build inputs, and QA receipts are in ~/pgsty/artifacts/postgis37-el8-20261105/. On the same day, 33 normal RPMs per architecture entered ~/pgsty/repo/yum/pgsql/el8.{aarch64,x86_64}/; 60 debug RPMs were archived separately under ~/pgsty/repo/pkg/debug/20261105/rpm/. Both repositories passed signing, metadata verification, and native EL8 client downloads of all 66 package placements. The import report is ~/pgsty/repo/reports/postgis37-el8-import-20261105.md; CDN synchronization has not been run.

Current package chain:

1. antlr4-runtime413 + antlr4-runtime413-devel (standalone ANTLR runtime)
2. babelfish-17 (Babelfish PG 17.7 kernel + four core extensions)

Key files:

• bin/babelfish.sh (generate source tarball + ANTLR zip)
• rpmbuild/SPECS/antlr4-runtime413.spec
• rpmbuild/SPECS/babelfish.spec
• rpmbuild/Makefile target: babelfish_all

Generate sources:

bin/babelfish.sh

Build on EL10A (example):

cp ~/pgsty/rpm/src/babelfish-17-17.7-5.4.0.tar.gz ~/rpmbuild/SOURCES/
cp ~/pgsty/rpm/src/antlr4-cpp-runtime-4.13.2-source.zip ~/rpmbuild/SOURCES/
cp ~/pgsty/rpm/rpmbuild/SPECS/antlr4-runtime413.spec ~/rpmbuild/SPECS/
cp ~/pgsty/rpm/rpmbuild/SPECS/babelfish.spec ~/rpmbuild/SPECS/

cd ~/rpmbuild
make babelfish_all

PG18 dev source can be generated with:

bin/babelfish.sh 18.0 6.0.0 BABEL_6_X_DEV__PG_18_X BABEL_6_X_DEV

All Deb Packages are signed with GPG key 9592A7BC7A682E7333376E09E7935D8DB9BD8B20 (B9BD8B20 Public key)

Maintainer: Ruohang Feng / @Vonng (rh@vonng.com)

License: Apache 2.0