packages/libs/postgresql/patches, 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

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

postgresql: update to version 16.3

2024-07-03T01:32:40Z

Switch to new major version 16. Use meson to build for target, however, old autotools-style configure is needed to clean the source directory before being able to run meson, and host build of the timezone compiler ('zic') also still requires using the old build system. See also https://www.postgresql.org/docs/16/release-16.html Signed-off-by: Daniel Golle

postgresql: update to version 15.3

2023-08-05T11:18:20Z

Fixes security issues: * CVE-2023-2454 * CVE-2023-2455 See release notes for details: https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/ Signed-off-by: Daniel Golle

postgresql: update to version 15.1

2023-01-14T01:47:56Z

https://www.postgresql.org/docs/release/15.0/ https://www.postgresql.org/docs/release/15.1/ A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. Do not backport to release branch which should remain on version 14. Signed-off-by: Daniel Golle

postgresql: update to version 14.6

2022-12-20T01:45:18Z

This release contains a variety of fixes from 14.5. See https://www.postgresql.org/docs/release/14.6/ for details. Signed-off-by: Daniel Golle

postgresql: update to version 14.5

2022-09-07T21:56:35Z

Release date: 2022-08-11 Adresses CVE-2022-2625. For more details, please see the release notes[1]. [1]: https://www.postgresql.org/docs/release/14.5/ Signed-off-by: Daniel Golle

postgresql: update to 14.2

2022-03-18T23:47:14Z

Minor release with a large number of fixes and small changes. See release notes[1] for details. [1]: https://www.postgresql.org/docs/release/14.2/ Signed-off-by: Daniel Golle