packages/libs/postgresql/Makefile, branch master

postgresql: update to 18.3

2026-05-09T16:10:07Z

Major version update from 17.5 to 18.3. PostgreSQL 18 (released September 2025) brings: * Asynchronous I/O (AIO) for shared buffers, sequential scans, bitmap heap scans and pg_prewarm. * Skip scans for B-tree indexes. * Performance improvements for partition pruning. * Logical replication: improved replication of generated columns, protocol version 5. * Native UUIDv7 support. * Larger I/O for sequential and parallel scans. * Concurrent reindex of partitioned tables. * pg_dump: --filter for selective dumps. * Numerous SQL/JSON improvements. * New built-in role pg_signal_autovacuum_worker. 18.3 is the third maintenance release with bug fixes since 18.0. Drop the now obsolete pg_config_ext.h copy in Build/InstallDev: this header has been removed upstream in PostgreSQL 18. Link: https://www.postgresql.org/docs/release/18.0/ Link: https://www.postgresql.org/docs/release/18.3/ Signed-off-by: Daniel Golle

treewide: cleanup URLs

2026-05-08T20:28:27Z

This commit converts plain HTTP URLs to HTTPS, and updates old or outdated URLs. Signed-off-by: Yanase Yuki

treewide: remove FTP usage

2025-12-31T07:22:58Z

Drop obsolete protocol usage. Use HTTPS (if possible) or HTTP instead. Signed-off-by: Yanase Yuki

postgresql: fix missing symbols at runtime

2025-12-14T07:50:40Z

Fixes pgsql-server: the setup fails for any folder Fixes #27228 Sets postgresql-specific configure flags that configure cannot run-test to determine their value. This fixes improperly linked files that prevent database initialization (at least) from working on the device. Signed-off-by: Daniel F. Dickinson

postgresql: fix fails to start on mounted data directories

2025-10-25T05:37:54Z

This commit resolves a bug where the PostgreSQL service failed to start during the boot process when its data directory ($pgdata) was on a partition mounted via `/etc/fstab`. Because the filesystem is already mounted, no hotplug event is ever triggered, and the PostgreSQL service mistakenly waits for an event that will never happen. This fix adds a check to ensure the script does not skip starting the service if the data directory is on a mount point. Signed-off-by: Peiying Huang

treewide: drop anything related to uClibc

2025-09-25T05:38:39Z

uClibc-ng was removed in 2020 from OpenWrt main repo [1]. These things are leftovers. [1] https://git.openwrt.org/?p=openwrt/openwrt.git;a=commit;h=63fb175203bbf3b336804587c2f5b3a2d8132ec1 Signed-off-by: Josef Schlehofer

postgresql: update to 17.5

2025-07-08T16:26:25Z

See https://www.postgresql.org/docs/17/release-17-5.html Signed-off-by: Daniel Golle

postgresql: update to version 17.4

2025-04-26T14:51:08Z

See project release notes for more details: https://www.postgresql.org/docs/17/release-17-4.html https://www.postgresql.org/docs/17/release-17-3.html Signed-off-by: Daniel Golle

postgresql: update to version 17.2

2025-02-10T11:47:32Z

Update PostgreSQL to new (major) version 17.2 See https://www.postgresql.org/docs/release/17.2/ for more details. Signed-off-by: Daniel Golle

Revert "postgresql: update to version 16.3"

2024-07-09T10:09:18Z

This reverts commit 6a46887e60d969cf718de3a212aa1847277ed4b3 from PR https://github.com/openwrt/packages/pull/24327 Postgresql version upgrade fails in buildbot for all targets with error like: [236/1612] Generating src/fe_utils/psqlscan with a custom command FAILED: src/fe_utils/psqlscan.c /builder/shared-workdir/build/sdk/staging_dir/host/bin/python3 ../src/tools/pgflex --builddir . --srcdir .. --privatedir src/fe_utils/psqlscan.c.p --flex /builder/shared-workdir/build/sdk/staging_dir/host/bin/flex --perl /builder/shared-workdir/build/sdk/staging_dir/host/bin/perl -i ../src/fe_utils/psqlscan.l -o src/fe_utils/psqlscan.c --no-backup --fix-warnings -- -Cfe -p -p flex: fatal internal error, exec of /builder/shared-workdir/build/staging_dir/host/bin/m4 failed [237/1612] Compiling C object src/interfaces/libpq/libpq.so.5.16.p/pqexpbuffer.c.o ninja: build stopped: subcommand failed. make[3]: *** [Makefile:264: /builder/shared-workdir/build/sdk/build_dir/target-aarch64_cortex-a53_musl/postgresql-16.3/.built] Error 1 Several dozen packages depend upon postgresql, so the fallout is rather large. Let's revert the upgrade until a fix is found. Signed-off-by: Hannu Nyman