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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

non port: databases/postgresql15-server/distinfo

Number of commits found: 15

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, 8 Feb 2024
21:28 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 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
commit hash: 6fa897631d45dd11a5b1fcea5993590f9ccbef48 commit hash: 6fa897631d45dd11a5b1fcea5993590f9ccbef48 commit hash: 6fa897631d45dd11a5b1fcea5993590f9ccbef48 commit hash: 6fa897631d45dd11a5b1fcea5993590f9ccbef48 6fa8976
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, 10 Aug 2023
14:13 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: Update to latest versions.

PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3
Released.

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.4, 14.9, 13.12, 12.16,
and 11.21, as well as the third beta release of PostgreSQL 16. This
release fixes two security vulnerabilities and over 40 bugs reported
over the last several months.

If you use BRIN indexes to look up NULL values, you will need to reindex
them after upgrading to this release. On PostgreSQL 12 and above, you
can use REINDEX CONCURRENTLY to avoid blocking writes to the affected
index and table, for example:

REINDEX INDEX CONCURRENTLY your_index_name;

Also, remove the patch for postgresql.conf.sample suggesting to turn off
update_process_title [1], since it is no longer a problem.

Release
notes:	https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/

[1]:		https://commitfest.postgresql.org/19/1715/
commit hash: 3554a40b0542d6b01a2a92dc78323880ac5aba3c commit hash: 3554a40b0542d6b01a2a92dc78323880ac5aba3c commit hash: 3554a40b0542d6b01a2a92dc78323880ac5aba3c commit hash: 3554a40b0542d6b01a2a92dc78323880ac5aba3c 3554a40
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
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
Tuesday, 18 Oct 2022
08:21 Li-Wen Hsu (lwhsu) search for other commits by this committer
databases/postgresql15-server: Fix distinfo

Reported by:	VVD <vvd@unislabs.com>
commit hash: 465f89a1b27cea122099c00c56f6719322edec50 commit hash: 465f89a1b27cea122099c00c56f6719322edec50 commit hash: 465f89a1b27cea122099c00c56f6719322edec50 commit hash: 465f89a1b27cea122099c00c56f6719322edec50 465f89a
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
Thursday, 6 Oct 2022
13:14 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql15-*: update to 15.rc2

Several bug fixes were applied for PostgreSQL 15 during the RC 1 period.
These include:

Reverting the "optimized order of GROUP BY keys" feature.
Fix behavior for the \g command in psql with multi-command strings.
Fix memory leak in single-column sorts.
Fix for behavior of PQsslAttribute libpq function.

To upgrade to PostgreSQL 15 RC 2 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/static/upgrading.html
Release
notes:	https://www.postgresql.org/about/news/postgresql-15-rc-2-released-2521/
commit hash: 5eb002e7f2ff544d5442e398d59943340eb56383 commit hash: 5eb002e7f2ff544d5442e398d59943340eb56383 commit hash: 5eb002e7f2ff544d5442e398d59943340eb56383 commit hash: 5eb002e7f2ff544d5442e398d59943340eb56383 5eb002e
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, 4 Jul 2022
11:26 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql15-*: update to 15beta2
commit hash: 28a97bf7074e8d76753800989c69370597781507 commit hash: 28a97bf7074e8d76753800989c69370597781507 commit hash: 28a97bf7074e8d76753800989c69370597781507 commit hash: 28a97bf7074e8d76753800989c69370597781507 28a97bf
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: 15