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/postgresql11-server/files/postgresql.in

Number of commits found: 9

Sunday, 31 Dec 2023
00:06 Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/postgresql11: Sunset
commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 commit hash: bbd8259de39f261bcd44716957c77536b3648bd6 bbd8259
Thursday, 28 Dec 2023
10:20 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-server: Properly set login class at start

PR:	275851 (submitted by takeda at takeda.tk)
commit hash: 16f2f4c4df2ddeefb9612870166e6f15237cc4d4 commit hash: 16f2f4c4df2ddeefb9612870166e6f15237cc4d4 commit hash: 16f2f4c4df2ddeefb9612870166e6f15237cc4d4 commit hash: 16f2f4c4df2ddeefb9612870166e6f15237cc4d4 16f2f4c
Tuesday, 15 Nov 2022
15:40 Dmitry Marakasov (amdmi3) search for other commits by this committer
databases/postgresql*-server: require mountlate in rc.d scripts

PostgreSQL server may use late-mounted filesystems, so require these
in rc.d scripts. Real life example is when /tmp is late-mounted tmpfs
atop of ZFS, and if posgresql-server starts before mountlate, its
socket which resides on /tmp is hidden under tmpfs which is mounted
afterwards.

PR:		267500
Approved by:	maintainer timeout (pgsql, 2 weeks)
commit hash: d512e8cce2abc9375784bc1dc4c91d5353e867a0 commit hash: d512e8cce2abc9375784bc1dc4c91d5353e867a0 commit hash: d512e8cce2abc9375784bc1dc4c91d5353e867a0 commit hash: d512e8cce2abc9375784bc1dc4c91d5353e867a0 d512e8c
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
Tuesday, 1 Jun 2021
13:59 Palle Girgensohn (girgen) search for other commits by this committer
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
commit hash: 8d831eb43aba59013b948830cbd4b22b45deb223 commit hash: 8d831eb43aba59013b948830cbd4b22b45deb223 commit hash: 8d831eb43aba59013b948830cbd4b22b45deb223 commit hash: 8d831eb43aba59013b948830cbd4b22b45deb223 8d831eb
Saturday, 15 May 2021
09:12 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-*: Upgrade to latest version

PostgreSQL 13.3, 12.7, 11.12, 10.17, and 9.6.22 Released!

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 13.3, 12.7, 11.12, 10.17, and
9.6.22. This release closes three security vulnerabilities and fixes over 45
bugs reported over the last three months.

Security fixes in this release:

CVE-2021-32027: Buffer overrun from integer overflow in array subscripting
                calculations

CVE-2021-32028: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE

CVE-2021-32029: Memory disclosure in partitioned-table UPDATE ... RETURNING

Also plenty of bug fixes. See the release note for details.

Changes to the port:

Make sure we use the matching version of llvm. This fixes a problem with the
llvm version string not being monotonically increasing with the version
number. [1]

Better pkg message about checksums for postgresql 12+. [2] [4]

Adjust login class parameter to adhere to the documentation in rc.subr(8) [3]:
  The rc.conf parameter for the login class of the postgresql daemon has
  changed name from postgresql_class to postgresql_login_class, since
  rc.subr(8) states that the parameter should be named ${name}_login_class.

Allow parallel builds. [5]

Correct the directory name for the user postgres in pkg message. [6]

PR:		250824 [1], 253558 [2], 236060 [3], 233106 [4],  230656 [5]
PR:		226674 [6]
Submitted by:	Michael Zhilin [2], Michael Zhilin [3], Dmitry Chestnykh [4]
Submitted by:	Steve Wills [5], knezour [6]

Security:	76e0bb86-b4cb-11eb-b9c9-6cc21735f730
Security:	62da9702-b4cc-11eb-b9c9-6cc21735f730

Release notes:	https://www.postgresql.org/docs/release/
commit hash: ab83f2b4bb78a718efa5c43247ba1e1d207f99b6 commit hash: ab83f2b4bb78a718efa5c43247ba1e1d207f99b6 commit hash: ab83f2b4bb78a718efa5c43247ba1e1d207f99b6 commit hash: ab83f2b4bb78a718efa5c43247ba1e1d207f99b6 ab83f2b
Tuesday, 6 Apr 2021
14:31 Mathieu Arnold (mat) search for other commits by this committer
all: Remove all other $FreeBSD keywords.
commit hash: 135fdeebb99c3569e42d8162b265e15d29bd937d commit hash: 135fdeebb99c3569e42d8162b265e15d29bd937d commit hash: 135fdeebb99c3569e42d8162b265e15d29bd937d commit hash: 135fdeebb99c3569e42d8162b265e15d29bd937d 135fdee
Thursday, 9 May 2019
22:32 girgen search for other commits by this committer
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
columns; this data is consulted during the query planning process. Prior
to this release, a user able to execute SQL queries with permissions to
read a given column could craft a leaky operator that could read
whatever data had been sampled from that column.  If this happened to
include values from rows that the user is forbidden to see by a row
security policy, the user could effectively bypass the policy.  This is
fixed by only allowing a non-leakproof operator to use this data if
there are no relevant row security policies for the table.

This issue is present in PostgreSQL 9.5, 9.6, 10, and 11. The PostgreSQL
project thanks Dean Rasheed for reporting this problem.

Also fix a FreeBSD port problem with LLVM [1] and add promote command
to `service postgresql` [2]

PR:	236100, 234879
Submitted by:	tomonori.usaka@ubin.jp [1], Trix Farrar [2]
Original commitRevision:501149 
Sunday, 21 Oct 2018
21:55 girgen search for other commits by this committer
Minor patch to fix the default data directory used on startup.

Submitted by:	Jonathan Chen
PR:		232487
Original commitRevision:482724 

Number of commits found: 9