PostgreSQL Build pg-nightly-20260531

PostgreSQL Multi-Version Build - pg-nightly-20260531

Item	Value
Build time	2026-05-31 01:23:22 CST
Trigger	schedule
Commit	cc9b43a
Run	#42

Packages

All packages include bundled runtime libraries and contrib extensions.
Minimum requirement: Linux kernel >= 3.10, glibc >= 2.36.
Build OS: debian:12.

Major	Full Version	amd64	arm64
14	latest patch	✅	✅
15	latest patch	✅	✅
16	latest patch	✅	✅
17	latest patch	✅	✅
18	latest patch	✅	✅

Features

Feature	Status
SSL/TLS	✅ (--with-openssl)
ICU	✅ (--with-icu)
XML / XSLT	✅
LDAP	✅
GSSAPI/Kerberos	✅
PAM	✅
LZ4	✅ (>= 14)
Zstandard	✅ (>= 15)
Perl PL	✅
Python PL	✅ (python3)
Tcl PL	✅
contrib	✅ (all standard extensions)
Bundled libs	✅

Install

# Example: PostgreSQL 17.x on amd64 (replace with actual version)
ASSET="postgresql-17.5-debian12-amd64.tar.gz"
wget https://github.com/QEStudio/database-build/releases/download/pg-nightly-20260531/${ASSET}
wget https://github.com/QEStudio/database-build/releases/download/pg-nightly-20260531/SHA256SUMS.txt
sha256sum -c SHA256SUMS.txt --ignore-missing

# Extract to /opt (or any directory)
sudo tar -xzf ${ASSET} -C /opt/
# or user-local
tar -xzf ${ASSET} -C ~/

# Initialize cluster (first time only)
DATADIR=/opt/postgresql-17.5/data \
  /opt/postgresql-17.5/scripts/initdb.sh

# Start
PORT=5432 /opt/postgresql-17.5/scripts/start-pg.sh

# Connect
/opt/postgresql-17.5/scripts/psql.sh -U $(whoami)

# Status
/opt/postgresql-17.5/scripts/status-pg.sh

# Stop
/opt/postgresql-17.5/scripts/stop-pg.sh

Directory structure

/opt/postgresql-<version>/
├── bin/
│   ├── postgres           # wrapper (sets LD_LIBRARY_PATH)
│   ├── postgres.bin       # real binary
│   ├── psql / psql.bin
│   ├── initdb / initdb.bin
│   ├── pg_ctl / pg_ctl.bin
│   ├── pg_dump / pg_dump.bin
│   └── ...
├── lib/
│   ├── postgresql/        # extensions (.so plugins)
│   └── private/           # bundled runtime .so files
├── share/postgresql/      # SQL files, timezone data, etc.
├── include/               # C headers
├── data/                  # cluster data directory (after initdb)
├── logs/                  # log files
├── run/                   # Unix socket / PID file
└── scripts/
    ├── initdb.sh          # initialize cluster
    ├── start-pg.sh        # start server
    ├── stop-pg.sh         # stop server (fast mode)
    ├── status-pg.sh       # show server status
    └── psql.sh            # quick psql via Unix socket