notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Ukraine
FreshPorts needs to find a new hosting provide willing to take a 2U chassis and host it free of charge. This is part of the FreshPorts project. Preferably in the Austin area. This is not a primary server, but it used for development.
non port: databases/postgresql11-server/pkg-plist-server
SVNWeb

Number of commits found: 11

Fri, 12 Aug 2022
[ 09:05 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:2e7e556d443e7ff948d0936ae65ead36825f5544  2e7e556  (Only the first 10 of 17 ports in this commit are shown above. View all ports for this commit)
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/
Thu, 19 May 2022
[ 13:36 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:5b11f47f0d59c95f6dcf1ff75badede5ec84e72e  5b11f47  (Only the first 10 of 54 ports in this commit are shown above. View all ports for this commit)
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
Thu, 11 Nov 2021
[ 14:37 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:d3db7630c79762949ca7d0f3cbf1db128ebecca4  d3db763  (Only the first 10 of 19 ports in this commit are shown above. View all ports for this commit)
databases/postgresql??-*: updated to latest version

This release contains a variety of fixes from the previous version.

A dump/restore is not required for those running the same major version.
However, note that installations using physical replication should
update standby servers before the primary server, as explained in the
release notes.

Also, several bugs have been found that may have resulted in corrupted
indexes, as explained in the next several changelog entries.  If any of
those cases apply to you, it's recommended to reindex possibly-affected
indexes after updating.

This release also mitigates two possible man-in-the-middle attacks.

Security:	2ccd71bd-426b-11ec-87db-6cc21735f730
Release notes:	https://www.postgresql.org/docs/release/14.1/
Thu, 20 May 2021
[ 14:35 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:21a4d52359f0e59b4f0dbb97212db803352e067e  21a4d52 
databases/postgresql1[123]-server: remove trailing space in pkg-plist
Mon, 15 Jun 2020
[ 06:56 girgen search for other commits by this committer ] Original commit   Revision:538854
Fix bad plist substitution

PR:		247226
Reported by:	Garrett Wollman
Sun, 17 May 2020
[ 20:37 girgen search for other commits by this committer ] Original commit   Revision:535676 (Only the first 10 of 36 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 12.3, 11.8, 10.13,
9.6.18, and 9.5.22.  This release fixes one security issue found in the
PostgreSQL server and over 75 bugs reported over the last three months.

Please plan to update at your earliest convenience.

Update the backup warning text. [1]

Add plpython and plperl libs for hstore, jsonb and ltree for the versions where
they exist. These libs are added to the postgresql??-plpython and -plperl
ports, inspired by [2].

PR:		237910 [1], 245246 [2]
Submitted by:	Francesco [1], Loic Bartoletti [2]
Mon, 21 Oct 2019
[ 10:10 girgen search for other commits by this committer ] Original commit   Revision:515099
Fix PLIST problems when building with LLVM but without GSSAPI or OPENSSL.

PR:		241166
Submitted by:	Artyom Davidov
Thu, 27 Jun 2019
[ 21:28 girgen search for other commits by this committer ] Original commit   Revision:505245 (Only the first 10 of 22 ports in this commit are shown above. View all ports for this commit)
Upgrade PostgreSQL to latest version

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 11.4, 10.9, 9.6.14, 9.5.18, and
9.4.23, as well as the second beta of PostgreSQL 12. This release fixes one
security issue and over 25 bugs since the previous cumulative update in May.

This release is made outside of the normal update release schedule as the
security vulnerability was determined to be critical enough to distribute the
fix as quickly as possible. Users who are running PostgreSQL 10, PostgreSQL 11,
or the PostgreSQL 12 beta should upgrade as soon as possible.

All other users should plan to apply this update at the next scheduled
downtime.

Release notes:	https://www.postgresql.org/about/news/1949/
Security:	245629d4-991e-11e9-82aa-6cc21735f730
Thu, 9 May 2019
[ 22:32 girgen search for other commits by this committer ] Original commit   Revision:501149 (Only the first 10 of 17 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.3, 10.8, 9.6.13,
9.5.17, and 9.4.22. This release fixes two security issues in the
PostgreSQL server, a security issue found in two of the PostgreSQL
Windows installers, and over 60 bugs reported over the last three months.

Security:	CVE-2019-10129: Memory disclosure in partition routing

Prior to this release, a user running PostgreSQL 11 can read arbitrary
bytes of server memory by executing a purpose-crafted INSERT statement
to a partitioned table.

Security:	CVE-2019-10130: Selectivity estimators bypass row security policies

PostgreSQL maintains statistics for tables by sampling data available in
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Fri, 15 Feb 2019
[ 11:02 girgen search for other commits by this committer ] Original commit   Revision:492989 (Only the first 10 of 34 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.2, 10.7, 9.6.12,
9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL
interfaces with `fsync()` and includes fixes for partitioning and over
70 other bugs that were reported over the past three months.

Users should plan to apply this update at the next scheduled downtime.

FreeBSD port adds OPTIONS knob to support LLVM JIT. [1]

Highlight: Change in behavior with fsync()
------------------------------------------

When available in an operating system and enabled in the configuration
file (which it is by default), PostgreSQL uses the kernel function
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Fri, 19 Oct 2018
[ 21:32 girgen search for other commits by this committer ] Original commit   Revision:482456 (Only the first 10 of 26 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group today announced the release of
PostgreSQL 11, the latest version of the world's most advanced open
source database.

PostgreSQL 11 provides users with improvements to overall performance of
the database system, with specific enhancements associated with very
large databases and high computational workloads. Further, PostgreSQL 11
makes significant improvements to the table partitioning system, adds
support for stored procedures capable of transaction management,
improves query parallelism and adds parallelized data definition
capabilities, and introduces just-in-time (JIT) compilation for
accelerating the execution of expressions in queries.

"For PostgreSQL 11, our development community focused on adding features
that improve PostgreSQL's ability to manage very large databases," said
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 11