notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it is already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

non port: databases/postgresql15-server/pkg-plist-server

Number of commits found: 14

Thursday, 8 May 2025
20:00 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: Update to latest version

PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 Released!

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 17.5, 16.9, 15.13, 14.18,
and 13.21. This release fixes 1 security vulnerability and over 60 bugs
reported over the last several months.

Security:	78b8e808-2c45-11f0-9a65-6cc21735f730
Release
notes:	https://www.postgresql.org/about/news/postgresql-175-169-1513-1418-and-1321-released-3072/
commit hash: a9608d62ae7125d78cd9f16748f786c8581699ad commit hash: a9608d62ae7125d78cd9f16748f786c8581699ad commit hash: a9608d62ae7125d78cd9f16748f786c8581699ad commit hash: a9608d62ae7125d78cd9f16748f786c8581699ad a9608d6
Thursday, 9 May 2024
22:34 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: Update to latest versions

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)
commit hash: ade1c57e3a72ec9c4a7c02ce28dbfbd5efcce373 commit hash: ade1c57e3a72ec9c4a7c02ce28dbfbd5efcce373 commit hash: ade1c57e3a72ec9c4a7c02ce28dbfbd5efcce373 commit hash: ade1c57e3a72ec9c4a7c02ce28dbfbd5efcce373 ade1c57
Thursday, 9 Nov 2023
15:09 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: update to latest version

PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 16.1, 15.5, 14.10, 13.13,
12.17, and 11.22 This release fixes three security vulnerabilities and
over 55 bugs reported over the last several months.

Release
notes:	https://www.postgresql.org/about/news/postgresql-161-155-1410-1313-1217-and-1122-released-2749/
Security:	CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Security:	31f45d06-7f0e-11ee-94b4-6cc21735f730
Security:	0f445859-7f0e-11ee-94b4-6cc21735f730
Security:	bbb18fcb-7f0d-11ee-94b4-6cc21735f730
commit hash: a5d53f45faf9f85a1bbdf6113c6b456569a6757f commit hash: a5d53f45faf9f85a1bbdf6113c6b456569a6757f commit hash: a5d53f45faf9f85a1bbdf6113c6b456569a6757f commit hash: a5d53f45faf9f85a1bbdf6113c6b456569a6757f a5d53f4
Thursday, 11 May 2023
15:42 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-server: update to latest version

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.3, 14.8, 13.11, 12.15,
and 11.20. This release fixes two security vulnerabilities over 80 bugs
reported over the last several months.

CVE-2023-2454: CREATE SCHEMA ... schema_element defeats protective search_path
changes.

This enabled an attacker having database-level CREATE privilege to
execute arbitrary code as the bootstrap superuser. Database owners have
that right by default, and explicit grants may extend it to other users.

CVE-2023-2455: Row security policies disregard user ID changes after inlining.

While CVE-2016-2193 fixed most interaction between row security and user
ID changes, it missed a scenario involving function inlining. This leads
to potentially incorrect policies being applied in cases where
role-specific policies are used and a given query is planned under one
role and then executed under other roles. This scenario can happen under
security definer functions or when a common user and query is planned
initially and then re-used across multiple SET ROLEs. Applying an
incorrect policy may permit a user to complete otherwise-forbidden reads
and modifications. This affects only databases that have used CREATE
POLICY to define a row security policy.

Security:	fbb5a260-f00f-11ed-bbae-6cc21735f730
Security:	4b636f50-f011-11ed-bbae-6cc21735f730
Release-notes:	https://www.postgresql.org/docs/release/
commit hash: 3fd6f200dc8c12022515f7c3f662df148941e261 commit hash: 3fd6f200dc8c12022515f7c3f662df148941e261 commit hash: 3fd6f200dc8c12022515f7c3f662df148941e261 commit hash: 3fd6f200dc8c12022515f7c3f662df148941e261 3fd6f20
Thursday, 9 Feb 2023
14:52 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: upgrade to latest versions

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.2, 14.7, 13.10, 12.14,
and 11.19. This release closes one security vulnerability and fixes over
60 bugs reported over the last several months.

Release notes:	https://www.postgresql.org/docs/release/
Security:	CVE-2022-41862: Client memory disclosure when
		connecting, with Kerberos, to modified server.
commit hash: 8f04ac817353175e8f73e8561d404b81b9d20ce4 commit hash: 8f04ac817353175e8f73e8561d404b81b9d20ce4 commit hash: 8f04ac817353175e8f73e8561d404b81b9d20ce4 commit hash: 8f04ac817353175e8f73e8561d404b81b9d20ce4 8f04ac8
Saturday, 19 Nov 2022
08:13 Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/postgresql15-server: Fix PLIST substitution for consistency

- Change %%PG_USER%%-15.mo to postgres-15.mo
- Change foo-15.mo to foo-%%PG_VERSION%%.mo

Approved by:	portmgr (blanket)
commit hash: 39811feb087eda94889a94578eeac93a2624c55f commit hash: 39811feb087eda94889a94578eeac93a2624c55f commit hash: 39811feb087eda94889a94578eeac93a2624c55f commit hash: 39811feb087eda94889a94578eeac93a2624c55f 39811fe
Thursday, 10 Nov 2022
16:23 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresq??-*: update to latest version

PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.1, 14.6, 13.9, 12.13,
11.18, and 10.23. This release fixes 25 bugs reported over the last
several months.

This is the final release of PostgreSQL 10. PostgreSQL 10 will no longer
receive security and bug fixes. If you are running PostgreSQL 10 in a
production environment, we suggest that you make plans to upgrade.

Release notes:	https://www.postgresql.org/docs/release/
commit hash: 792a1db259a1e0b8588727d5a200dc62dac54ae8 commit hash: 792a1db259a1e0b8588727d5a200dc62dac54ae8 commit hash: 792a1db259a1e0b8588727d5a200dc62dac54ae8 commit hash: 792a1db259a1e0b8588727d5a200dc62dac54ae8 792a1db
Thursday, 13 Oct 2022
14:04 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql15-*: Update to 15.0

The PostgreSQL Global Development Group today announced the release of
PostgreSQL 15, the latest version of the world’s most advanced open
source database.

PostgreSQL 15 builds on the performance improvements of recent releases
with noticeable gains for managing workloads in both local and
distributed deployments, including improved sorting. This release
improves the developer experience with the addition of the popular MERGE
command, and adds more capabilities for observing the state of the
database.

Release
notes:	https://www.postgresql.org/about/news/postgresql-15-released-2526/
commit hash: f46b3a4cb93f012d96a5304d07eed1c265ed62d9 commit hash: f46b3a4cb93f012d96a5304d07eed1c265ed62d9 commit hash: f46b3a4cb93f012d96a5304d07eed1c265ed62d9 commit hash: f46b3a4cb93f012d96a5304d07eed1c265ed62d9 f46b3a4
Monday, 3 Oct 2022
02:18 Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/postgresql15-server: Fix PLIST

===>  Building package for postgresql15-server-15.r1
pkg-static: Unable to access file
/usr/ports/works/usr/ports/databases/postgresql15-server/work/stage/usr/local/share/postgresql/timezone/Etc/GMT-15:No
such file or directory
*** Error code 1

Stop.
make: stopped in /usr/ports/databases/postgresql15-server

Approved by:	portmgr (blanket)
commit hash: 9fca338c4028637502dc167ff97aec861b788997 commit hash: 9fca338c4028637502dc167ff97aec861b788997 commit hash: 9fca338c4028637502dc167ff97aec861b788997 commit hash: 9fca338c4028637502dc167ff97aec861b788997 9fca338
Thursday, 29 Sep 2022
14:24 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql15-*: Upgrade to 15.0-rc1

The PostgreSQL Global Development Group announces that the first release
candidate of PostgreSQL 15 is now available for download. As a release
candidate, PostgreSQL 15 RC 1 will be mostly identical to the initial
release of PostgreSQL 15, though some more fixes may be applied prior to
the general availability of PostgreSQL 15.

To upgrade to PostgreSQL 15 RC 1 from earlier versions of PostgreSQL,
you will need to use a major version upgrade strategy, e.g. pg_upgrade
or pg_dump / pg_restore. For more information, please visit the
documentation section on upgrading.

URL: https://www.postgresql.org/docs/15/upgrading.html
commit hash: 707821058479b540d91e44f6398d6fe8c569b52e commit hash: 707821058479b540d91e44f6398d6fe8c569b52e commit hash: 707821058479b540d91e44f6398d6fe8c569b52e commit hash: 707821058479b540d91e44f6398d6fe8c569b52e 7078210
Thursday, 8 Sep 2022
13:49 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql15-server: update to 15beta5

This release contains previews of all features that will be available
when PostgreSQL 15 is made generally available, though some details of
the release can change during the beta period.

To upgrade to PostgreSQL 15 Beta 4 from an earlier beta or previous
version of PostgreSQL, you will need to use a strategy similar to
upgrading between major versions of PostgreSQL (e.g. pg_upgrade or
pg_dump / pg_restore). For more information, please visit the
documentation section on upgrading.

URL:		https://www.postgresql.org/about/news/postgresql-15-beta-4-released-2507/
Release notes:	https://www.postgresql.org/docs/15/release-15.html
commit hash: 31290cc3551e0dee46b406fa154dfe30e12ac04e commit hash: 31290cc3551e0dee46b406fa154dfe30e12ac04e commit hash: 31290cc3551e0dee46b406fa154dfe30e12ac04e commit hash: 31290cc3551e0dee46b406fa154dfe30e12ac04e 31290cc
Friday, 12 Aug 2022
09:05 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: Update to latest version

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.5, 13.8, 12.12, 11.17,
and 10.22, as well as the third beta release of PostgreSQL 15. This
release closes one security vulnerability and fixes over 40 bugs
reported over the last three months.

PostgreSQL 10 will stop receiving fixes on November 10, 2022. If you are
running PostgreSQL 10 in a production environment, we strongly advise
that you make plans to upgrade to a newer, supported version of
PostgreSQL so you can continue to receive bug and security fixes.

Security:	CVE-2022-2625
Release
notes:	https://www.postgresql.org/about/news/postgresql-145-138-1212-1117-1022-and-15-beta-3-released-2496/
commit hash: 2e7e556d443e7ff948d0936ae65ead36825f5544 commit hash: 2e7e556d443e7ff948d0936ae65ead36825f5544 commit hash: 2e7e556d443e7ff948d0936ae65ead36825f5544 commit hash: 2e7e556d443e7ff948d0936ae65ead36825f5544 2e7e556
Monday, 23 May 2022
10:46 Palle Girgensohn (girgen) search for other commits by this committer
postgresql??-server: fix regression in the rc script

The rc script was converted to use a SUB_LIST variable, but I failed to
introduce the variable correctly in the Makefile. [1]

The plist for postgresql15-server was incorrect. Fixed this as well.

PR:	264097 [1]
commit hash: 9230d75a823cc4191f4ad358422762b175e91ccd commit hash: 9230d75a823cc4191f4ad358422762b175e91ccd commit hash: 9230d75a823cc4191f4ad358422762b175e91ccd commit hash: 9230d75a823cc4191f4ad358422762b175e91ccd 9230d75
Thursday, 19 May 2022
13:36 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: add postgresql-15 to the ports tree

Introduce PostgreSQL-15 to the ports tree.

Make version 15 the master port, and add plist parameter for the
postgresql version.

Release notes:	https://www.postgresql.org/docs/devel/release.html
commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e commit hash: 5b11f47f0d59c95f6dcf1ff75badede5ec84e72e 5b11f47

Number of commits found: 14