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

Number of commits found: 10

Sunday, 14 Jan 2024
10:00 Palle Girgensohn (girgen) search for other commits by this committer
postgresql??-server: fix rc script bug when using profiles

Submitted by:	John W. O'Brien
commit hash: 585adf391b886f17b2e2508d0008927702147bac commit hash: 585adf391b886f17b2e2508d0008927702147bac commit hash: 585adf391b886f17b2e2508d0008927702147bac commit hash: 585adf391b886f17b2e2508d0008927702147bac 585adf3
Thursday, 11 Jan 2024
21:50 Palle Girgensohn (girgen) search for other commits by this committer
databases/postgresql??-server: honour login class set in /etc/passwd

If postgresql_login_class is not set, honour the setting in /etc/passwd.
The previous commit ignored the passwd setting and set the login class
to "default" if it was left unset.

PR:     275851
commit hash: 4e2b811c04ce0643e2f526f65a0cef442c14d4a0 commit hash: 4e2b811c04ce0643e2f526f65a0cef442c14d4a0 commit hash: 4e2b811c04ce0643e2f526f65a0cef442c14d4a0 commit hash: 4e2b811c04ce0643e2f526f65a0cef442c14d4a0 4e2b811
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
Thursday, 29 Apr 2021
20:15 Dmitry Marakasov (amdmi3) search for other commits by this committer
databases/postgresql1*-server: update comments in rc scripts
commit hash: e4768aedbaf9ed687dbc1d5d4dee242a67219aa9 commit hash: e4768aedbaf9ed687dbc1d5d4dee242a67219aa9 commit hash: e4768aedbaf9ed687dbc1d5d4dee242a67219aa9 commit hash: e4768aedbaf9ed687dbc1d5d4dee242a67219aa9 e4768ae
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
Friday, 25 Sep 2020
16:23 girgen search for other commits by this committer
Fix datadir 12->13

Submitted by:	Raivo Hool
Original commitRevision:550053 

Number of commits found: 10