PostgreSQL Multi-Version Build - pg-nightly-20260613
| Item |
Value |
| Build time |
2026-06-13 02:19:52 CST |
| Trigger |
schedule |
| Commit |
7f857c1 |
| Run |
#56 |
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-20260613/${ASSET}
wget https://github.com/QEStudio/database-build/releases/download/pg-nightly-20260613/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