notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Ukraine
NOTE: the WWW: line in pkg-descr was relocated to a WWW= line in Makefile. Each port in FreshPorts has a homepage link. Look for it right after the Description: on each port's home page.

Do I know someone who can pick up a server from 7401 E. Ben White Blvd. Austin TX?

The emphasis is on know, or recommended by someone I know. This is the original FreshPorts server, way past useful: RAID, 8GB RAM, etc. The drives need to be wiped and everything recycled.
non port: databases/postgresql14-server/Makefile
SVNWeb

Number of commits found: 22

Sat, 10 Sep 2022
[ 17:41 Stefan Eßer (se) search for other commits by this committer Author: Tobias Kortkamp ]    commit hash:e79fe1aabc5b83364240652d62b99198a9ccfb32  commit hash:e79fe1aabc5b83364240652d62b99198a9ccfb32  commit hash:e79fe1aabc5b83364240652d62b99198a9ccfb32  e79fe1a  (Only the first 10 of 195 ports in this commit are shown above. View all ports for this commit)
Fix WWW in parent/child ports

Many of the WWW are overwritten later which means the wrong value
is used. This did not happen before where the children were either
 a) just using the pkg-descr from the parents
 b) or had their own separate pkg-descr with custom WWW

Use WWW?= in parents when the child's WWW is different.

Children that use the same WWW as the parent can just inherit it,
i.e., the child WWW can be removed.

Approved by:	portmgr (implicit)
Wed, 7 Sep 2022
[ 21:10 Stefan Eßer (se) search for other commits by this committer ]    commit hash:b7f05445c00f2625aa19b4154ebcbce5ed2daa52  commit hash:b7f05445c00f2625aa19b4154ebcbce5ed2daa52  commit hash:b7f05445c00f2625aa19b4154ebcbce5ed2daa52  b7f0544  (Only the first 10 of 27931 ports in this commit are shown above. View all ports for this commit)
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Fri, 12 Aug 2022
[ 09:05 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:2e7e556d443e7ff948d0936ae65ead36825f5544  commit hash:2e7e556d443e7ff948d0936ae65ead36825f5544  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/
Wed, 20 Jul 2022
[ 14:21 Tobias C. Berner (tcberner) search for other commits by this committer ]    commit hash:d076ad94e206dda108061fe99ddb860d93cc6d16  commit hash:d076ad94e206dda108061fe99ddb860d93cc6d16  commit hash:d076ad94e206dda108061fe99ddb860d93cc6d16  d076ad9  (Only the first 10 of 718 ports in this commit are shown above. View all ports for this commit)
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Thu, 16 Jun 2022
[ 13:08 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:e8704075ff7970018fce6b7eeb03ca19dd44a303  commit hash:e8704075ff7970018fce6b7eeb03ca19dd44a303  commit hash:e8704075ff7970018fce6b7eeb03ca19dd44a303  e870407 
databases/postgresql14-server: update to 14.4

This release fixes an issue with all versions of PostgreSQL 14 that can
lead to silent corruption of indexes.

Since the release of PostgreSQL 14.0, there existed an issue with CREATE
INDEX CONCURRENTLY and REINDEX CONCURRENTLY that could cause silent data
corruption in indexes. This issue is fixed in the upcoming PostgreSQL
14.4 release.

If you ran either of these commands on any version of PostgreSQL 14
prior to 14.4, you may have experienced silent data corruption. You can
use the pg_amcheck command with the --heapallindexed flag to detect this
issue with B-tree indexes.

If you need an immediate remediation for this issue before the
PostgreSQL 14.4 release, you can run CREATE INDEX or REINDEX without
CONCURRENTLY. You can also run the reindexdb command and use the --jobs
flag for added parallelism, but do not use the --concurrently flag.

Once PostgreSQL 14.4 is released, you can safely use CREATE INDEX
CONCURRENTLY and REINDEX CONCURRENTLY to manage your indexes, as well as
the --concurrently flag on reindexdb.

URL:	https://www.postgresql.org/message-id/165473835807.573551.1512237163040609764%40wrigleys.postgresql.org
Mon, 23 May 2022
[ 10:46 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:9230d75a823cc4191f4ad358422762b175e91ccd  commit hash:9230d75a823cc4191f4ad358422762b175e91ccd  commit hash:9230d75a823cc4191f4ad358422762b175e91ccd  9230d75 
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]
Thu, 19 May 2022
[ 13:36 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:5b11f47f0d59c95f6dcf1ff75badede5ec84e72e  commit hash:5b11f47f0d59c95f6dcf1ff75badede5ec84e72e  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, 12 May 2022
[ 13:41 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63  commit hash:6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63  commit hash:6c00f6e30fbd66a5ccc7173c9f4aca3122cd4c63  6c00f6e  (Only the first 10 of 15 ports in this commit are shown above. View all ports for this commit)
databases/postgresql??-server: update to latest version

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.3, 13.7, 12.11, 11.16,
and 10.21. This release fixes over 50 bugs reported over the last three
months. This release closes one security vulnerability and fixes over 50
bugs reported over the last three months.

We encourage you to install this update at your earliest possible
convenience.

If you have any GiST indexes on columns using the ltree data type, you
will need to reindex them after upgrading.

For the full list of changes, please review the release notes.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Thu, 7 Apr 2022
[ 00:39 Jan Beich (jbeich) search for other commits by this committer ]    commit hash:268cee3b0227efd217869b43152e8936a05cb850  commit hash:268cee3b0227efd217869b43152e8936a05cb850  commit hash:268cee3b0227efd217869b43152e8936a05cb850  268cee3  (Only the first 10 of 179 ports in this commit are shown above. View all ports for this commit)
devel/icu: update to 71.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-71-1
Reported by:	GitHub (watch releases)
PR:		262654
Exp-run by:	antoine
Approved by:	fluffy
Wed, 16 Mar 2022
[ 18:28 Dimitry Andric (dim) search for other commits by this committer ]    commit hash:dbafe427a49b7feef6049e10e3398a0681c8ccd5  commit hash:dbafe427a49b7feef6049e10e3398a0681c8ccd5  commit hash:dbafe427a49b7feef6049e10e3398a0681c8ccd5  dbafe42 
databases/postgresql14-server: Avoid using llvm14

When the base system compiler is clang 14, the postgresql ports attempt
to build against the devel/llvm14 port. This will fail with several
compile errors as there are a few incompatible changes in the LLVM 14 C
and C++ APIs. Until upstream postgresql adapts to these changes, limit
the PG_LLVM_VERSION to a maximum of 13.

PR:		 261976
Approved by:	maintainer timeout (2 weeks)
MFH:		2022Q1
Thu, 10 Feb 2022
[ 14:17 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:7acb062c33ea0c0a2124a3b83bbf94c0352eb8ea  commit hash:7acb062c33ea0c0a2124a3b83bbf94c0352eb8ea  commit hash:7acb062c33ea0c0a2124a3b83bbf94c0352eb8ea  7acb062  (Only the first 10 of 11 ports in this commit are shown above. View all ports for this commit)
databases/postgresql??-server: Upgrade to latest version

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 14.2, 13.6, 12.10, 11.15,
and 10.20. This release fixes over 55 bugs reported over the last three
months.

Announcement:	https://www.postgresql.org/about/news/postgresql-142-136-1210-1115-and-1020-released-2402/
Release notes:	https://www.postgresql.org/docs/release/
Thu, 11 Nov 2021
[ 14:37 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:d3db7630c79762949ca7d0f3cbf1db128ebecca4  commit hash:d3db7630c79762949ca7d0f3cbf1db128ebecca4  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, 28 Oct 2021
[ 16:37 Jan Beich (jbeich) search for other commits by this committer ]    commit hash:f34ece3aa6a292628ea75c0e4dd2a04d879ab0a3  commit hash:f34ece3aa6a292628ea75c0e4dd2a04d879ab0a3  commit hash:f34ece3aa6a292628ea75c0e4dd2a04d879ab0a3  f34ece3  (Only the first 10 of 157 ports in this commit are shown above. View all ports for this commit)
devel/icu: update to 70.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-70-1
Reported by:	GitHub (watch releases)
PR:		258794
Exp-run by:	antoine
Thu, 30 Sep 2021
[ 12:55 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:a91450e0e5fa0b6660516cff216ae23f97bfd890  commit hash:a91450e0e5fa0b6660516cff216ae23f97bfd890  commit hash:a91450e0e5fa0b6660516cff216ae23f97bfd890  a91450e 
databases/postgresql14-server: Introducing PostgreSQL-14

PostgreSQL 14 brings a variety of features that help developers and
administrators deploy their data-backed applications. PostgreSQL
continues to add innovations on complex data types, including more
convenient access for JSON and support for noncontiguous ranges of data.
This latest release adds to PostgreSQL's trend on improving high
performance and distributed data workloads, with advances in connection
concurrency, high-write workloads, query parallelism and logical
replication.

Release notes:	https://www.postgresql.org/docs/14/release-14.html
Wed, 29 Sep 2021
[ 09:39 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:59611d61d70a85f4418f3f701db1b7baf58560ba  commit hash:59611d61d70a85f4418f3f701db1b7baf58560ba  commit hash:59611d61d70a85f4418f3f701db1b7baf58560ba  59611d6 
databases/postgresql14-server: fix openssl dependency

libpq.pc should not require openssl from ports when built with base -lssl

PR:	258760
Tue, 28 Sep 2021
[ 06:55 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:0edd2574e1dc068d39919f3a64f2b8f585390abb  commit hash:0edd2574e1dc068d39919f3a64f2b8f585390abb  commit hash:0edd2574e1dc068d39919f3a64f2b8f585390abb  0edd257 
databases/postgresql14-server: add support for lz4 compression
Fri, 24 Sep 2021
[ 08:51 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:66e70f54f403eab94e0d38de8f2b4d95bae37682  commit hash:66e70f54f403eab94e0d38de8f2b4d95bae37682  commit hash:66e70f54f403eab94e0d38de8f2b4d95bae37682  66e70f5 
databases/postgresql14: update to 14rc1

Release notes:	https://www.postgresql.org/docs/14/release-14.html
Thu, 12 Aug 2021
[ 16:23 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:a271b9d5b7b2c0eb57d1a09fc44f2ecbbad7bc5a  commit hash:a271b9d5b7b2c0eb57d1a09fc44f2ecbbad7bc5a  commit hash:a271b9d5b7b2c0eb57d1a09fc44f2ecbbad7bc5a  a271b9d  (Only the first 10 of 18 ports in this commit are shown above. View all ports for this commit)
databases/postgresql*: update to latest versions

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 13.4, 12.8, 11.13, 10.18, and
9.6.23, as well as the third beta release of PostgreSQL 14. This release closes
one security vulnerability and fixes over 75 bugs reported over the last three
months.

Turn off parallel builds since we continue to struggle with build problems when
it is activated. [1]

Avoid chasing latest LLVM version. [2]

PR:		256466 [1], 256167 [2]
Release notes:	https://www.postgresql.org/docs/release/
Security:	b471130b-fb86-11eb-87db-6cc21735f730
Thu, 24 Jun 2021
[ 19:09 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:377ebb0c61e53e0c4a44d363e66e9916c7469fe8  commit hash:377ebb0c61e53e0c4a44d363e66e9916c7469fe8  commit hash:377ebb0c61e53e0c4a44d363e66e9916c7469fe8  377ebb0 
databases/postgres14-*: Update to 14.0-beta2

Release notes:	https://www.postgresql.org/developer/beta/
Tue, 1 Jun 2021
[ 13:59 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:8d831eb43aba59013b948830cbd4b22b45deb223  commit hash:8d831eb43aba59013b948830cbd4b22b45deb223  commit hash:8d831eb43aba59013b948830cbd4b22b45deb223  8d831eb  (Only the first 10 of 12 ports in this commit are shown above. View all ports for this commit)
databases/postgresql??-server: rc-script should require DAEMON

Changeset ab83f2b4bb78 changed the startup order for Postgresql. The cleartmp
rc.d now comes after the Postgresql startup.  Unfortunately, Postgresql likes
to create a socket in /tmp/.s.PGSQL.5432. After cleartmp does its work, that
socket disappears from the filesystem.

Submitted by:	Jeroen Pulles
PR:		256335
Mon, 24 May 2021
[ 16:03 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:093fa95e0c3d78196916d36ddb234d2f1a5c9881  commit hash:093fa95e0c3d78196916d36ddb234d2f1a5c9881  commit hash:093fa95e0c3d78196916d36ddb234d2f1a5c9881  093fa95 
databases/postgresql14-server: fix data directory

PR:	256125
Thu, 20 May 2021
[ 14:38 Palle Girgensohn (girgen) search for other commits by this committer ]    commit hash:fccc45e5ff4a8aea150005196c0d4f2cbaeed5db  commit hash:fccc45e5ff4a8aea150005196c0d4f2cbaeed5db  commit hash:fccc45e5ff4a8aea150005196c0d4f2cbaeed5db  fccc45e  (Only the first 10 of 73 ports in this commit are shown above. View all ports for this commit)
databases/postgresql14-*: Add postgresql 14 beta1 the the ports tree.

Release notes:	https://www.postgresql.org/docs/devel/release-14.html

Also reintroduce parallel builds. Some components, namely plperl,
plpython, pltcl and contrib, fail to build properly when using parallel
builds. Something with static linking using `ar` that fails.
MAKE_JOBS_UNSAFE is set for these ports.

Number of commits found: 22