FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=main 2025-01-01T12:08:02Z 2025-01-01T12:08:02Z Rene Ladan rene@FreeBSD.org 2025-01-01T12:08:02Z urn:sha1:336f72ee03cc999303a0ac1e2fa94602fac0917b 2024-12-31 databases/postgresql12-server: PostgreSQL-12 is end-of-life 2024-11-21T14:35:13Z Palle Girgensohn girgen@FreeBSD.org 2024-11-21T14:20:16Z urn:sha1:6fbeba7f98faf8fe4d1f2bf7644247a0d8fb2fe0 The issues listed below affect PostgreSQL 17. Some of these issues may also affect other supported versions of PostgreSQL. - Restore functionality of ALTER ROLE .. SET ROLE and ALTER DATABASE .. SET ROLE. The fix for CVE-2024-10978 accidentally caused settings for role to not be applied if they came from non-interactive sources, including previous ALTER {ROLE|DATABASE} commands and the PGOPTIONS environment variable. - Restore compatibility for the timescaledb and other PostgreSQL extensions built using PostgreSQL prior to the 2024-11-14 release (17.0, 16.4, 15.8, 14.13, 13.16, 12.20, and earlier). This fix restores struct ResultRelInfo to its previous size, so that affected extensions don't need to be rebuilt. - Fix cases where a logical replication slot's restart_lsn could go backwards. - Avoid deleting still-needed WAL files during pg_rewind. - Fix race conditions associated with dropping shared statistics entries, which could lead to loss of statistics data. - Fix crash with ALTER TABLE when checking to see if an index's opclass options have changed if the table has an index with a non-default operator class. Security: 12e3feab-a29f-11ef-af48-6cc21735f730 2024-11-14T16:30:50Z Palle Girgensohn girgen@FreeBSD.org 2024-11-14T15:25:42Z urn:sha1:778499d5c21d30c2f04acd7b85cb311c8236534a PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released! The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21. This release fixes 4 security vulnerabilities and over 35 bugs reported over the last several months. Also add XML back as an active default option due to popular demand. [1] Clean up the ports a bit. PR: 269115 [1] Release notes: https://www.postgresql.org/docs/release/ Security: a03636f4-a29f-11ef-af48-6cc21735f730 Security: 12e3feab-a29f-11ef-af48-6cc21735f730 Security: a61ef21b-a29e-11ef-af48-6cc21735f730 Security: 3831292b-a29d-11ef-af48-6cc21735f730 2024-08-08T13:02:46Z Palle Girgensohn girgen@FreeBSD.org 2024-08-08T09:25:22Z urn:sha1:b4e71c8402d027a49eeddb5b585b591019654bb8 The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.4, 15.8, 14.13, 13.16, and 12.20. This release fixes 1 security vulnerability and over 55 bugs reported over the last several months. PR: 279671 - make the rc script service jails aware PR: 279536 - remove LLVM max version restriction PR: 278887 - SETENV -> SETENVI for -contrib ports Release notes: https://www.postgresql.org/docs/release/ 2024-05-09T22:34:46Z Palle Girgensohn girgen@FreeBSD.org 2024-05-09T20:13:22Z urn:sha1:ade1c57e3a72ec9c4a7c02ce28dbfbd5efcce373 PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released! The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.3, 15.7, 14.12, 13.15, and 12.19. This release fixes one security vulnerability and over 55 bugs reported over the last several months. Please note that the fix in this release for CVE-2024-4317 only fixes fresh PostgreSQL installations, namely those that are created with the initdb utility after this fix is applied. If you have a current PostgreSQL installation and are concerned about this issue, please follow the additional updating instructions provided in the CVE-2024-4317 description or the release notes for the remediation. [1] The script is installed as /usr/local/share/postgresql/fix-CVE-2024-4317.sql PostgreSQL 12 will stop receiving fixes on November 14, 2024. If you are running PostgreSQL 12 in a production environment, we suggest that you make plans to upgrade to a newer, supported version of PostgreSQL. Please see our versioning policy for more information. [1]: https://www.postgresql.org/support/security/CVE-2024-4317/ Security: d53c30c1-0d7b-11ef-ba02-6cc21735f730 PR: 277428 (remove unneded patch) PR: 260494 (remove deprecated INTDATE option) PR: 265860 (correct path for contrib README file in pkg-message) 2024-02-08T21:28:36Z Palle Girgensohn girgen@FreeBSD.org 2024-02-07T16:10:44Z urn:sha1:6fa897631d45dd11a5b1fcea5993590f9ccbef48 The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.2, 15.6, 14.11, 13.14, and 12.18. This release fixes one security vulnerability and over 65 bugs reported over the last several months. If you use GIN indexes, you may need to reindex after updating to this release. Please see the release notes for more information. URL: https://www.postgresql.org/about/news/postgresql-162-156-1411-1314-and-1218-released-2807/ Release notes: https://www.postgresql.org/docs/release/ Security: 19e6dd1b-c6a5-11ee-9cd0-6cc21735f730 2024-01-23T19:56:16Z Muhammad Moinur Rahman bofh@FreeBSD.org 2024-01-23T16:39:30Z urn:sha1:abdf012875d6c22bc8f7f418559b096eda1febde Approved by: portmgr (blanket) 2024-01-14T10:00:18Z Palle Girgensohn girgen@FreeBSD.org 2024-01-14T10:00:18Z urn:sha1:585adf391b886f17b2e2508d0008927702147bac Submitted by: John W. O'Brien 2024-01-11T21:50:31Z Palle Girgensohn girgen@FreeBSD.org 2024-01-11T21:50:31Z urn:sha1:4e2b811c04ce0643e2f526f65a0cef442c14d4a0 If postgresql_login_class is not set, honour the setting in /etc/passwd. The previous commit ignored the passwd setting and set the login class to "default" if it was left unset. PR: 275851 2023-12-28T10:20:24Z Palle Girgensohn girgen@FreeBSD.org 2023-12-28T10:20:24Z urn:sha1:16f2f4c4df2ddeefb9612870166e6f15237cc4d4 PR: 275851 (submitted by takeda at takeda.tk)