Created attachment 251379 [details] postgresql15 Hi, attached is a mechanical patch (untested) which makes the rc.d script service jails ready. This is a new feature in -current. The setup I've chosen is to allow ipv4/ipv6 access. It does not allow to use sysv IPC in a jail. IF you want to add this possibility, the config would need to be changed to "net_basic sysvipc" instead. The config can be overridden in rc.conf. See also: https://docs.freebsd.org/en/books/handbook/jails/#service-jails https://docs.freebsd.org/en/articles/rc-scripting/#rcng-service-jails Bye, Alexander.
Created attachment 251380 [details] postgresql16
Created attachment 251381 [details] postgresql14
Created attachment 251382 [details] postgresql13
Created attachment 251383 [details] postgresql12
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=b4e71c8402d027a49eeddb5b585b591019654bb8 commit b4e71c8402d027a49eeddb5b585b591019654bb8 Author: Palle Girgensohn <girgen@FreeBSD.org> AuthorDate: 2024-08-08 09:25:22 +0000 Commit: Palle Girgensohn <girgen@FreeBSD.org> CommitDate: 2024-08-08 13:02:46 +0000 databases/postgresql??-*: Update to latest minor versions The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.4, 15.8, 14.13, 13.16, and 12.20. This release fixes 1 security vulnerability and over 55 bugs reported over the last several months. PR: 279671 - make the rc script service jails aware PR: 279536 - remove LLVM max version restriction PR: 278887 - SETENV -> SETENVI for -contrib ports Release notes: https://www.postgresql.org/docs/release/ databases/postgresql12-client/Makefile | 6 ++++++ databases/postgresql12-contrib/Makefile | 4 ++-- databases/postgresql12-plperl/Makefile | 6 +++--- databases/postgresql12-plpython/Makefile | 4 ++-- databases/postgresql12-pltcl/Makefile | 4 ++-- databases/postgresql12-server/Makefile | 2 +- databases/postgresql12-server/distinfo | 6 +++--- databases/postgresql12-server/files/postgresql.in | 1 + databases/postgresql13-client/Makefile | 6 ++++++ databases/postgresql13-contrib/Makefile | 4 ++-- databases/postgresql13-plperl/Makefile | 6 +++--- databases/postgresql13-plpython/Makefile | 4 ++-- databases/postgresql13-pltcl/Makefile | 4 ++-- databases/postgresql13-server/Makefile | 2 +- databases/postgresql13-server/distinfo | 6 +++--- databases/postgresql13-server/files/postgresql.in | 1 + databases/postgresql14-client/Makefile | 6 ++++++ databases/postgresql14-contrib/Makefile | 4 ++-- databases/postgresql14-docs/Makefile | 2 +- databases/postgresql14-plperl/Makefile | 6 +++--- databases/postgresql14-plpython/Makefile | 4 ++-- databases/postgresql14-pltcl/Makefile | 4 ++-- databases/postgresql14-server/Makefile | 2 +- databases/postgresql14-server/distinfo | 6 +++--- databases/postgresql14-server/files/postgresql.in | 1 + databases/postgresql15-client/Makefile | 6 ++++++ databases/postgresql15-contrib/Makefile | 4 ++-- databases/postgresql15-docs/Makefile | 2 +- databases/postgresql15-plperl/Makefile | 6 +++--- databases/postgresql15-plpython/Makefile | 4 ++-- databases/postgresql15-pltcl/Makefile | 4 ++-- databases/postgresql15-server/Makefile | 2 +- databases/postgresql15-server/distinfo | 6 +++--- databases/postgresql15-server/files/postgresql.in | 1 + databases/postgresql16-client/Makefile | 6 ++++++ databases/postgresql16-contrib/Makefile | 4 ++-- databases/postgresql16-docs/Makefile | 2 +- databases/postgresql16-plperl/Makefile | 6 +++--- databases/postgresql16-plpython/Makefile | 4 ++-- databases/postgresql16-pltcl/Makefile | 4 ++-- databases/postgresql16-server/Makefile | 15 ++------------- databases/postgresql16-server/distinfo | 6 +++--- databases/postgresql16-server/files/postgresql.in | 1 + 43 files changed, 104 insertions(+), 80 deletions(-)
Committed. Thanks!
A commit in branch 2024Q3 references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=39b4d3ef50b6a7a093fe792abee9c2b416fd7339 commit 39b4d3ef50b6a7a093fe792abee9c2b416fd7339 Author: Palle Girgensohn <girgen@FreeBSD.org> AuthorDate: 2024-08-08 09:25:22 +0000 Commit: Torsten Zuehlsdorff <tz@FreeBSD.org> CommitDate: 2024-09-25 12:11:37 +0000 databases/postgresql??-*: Update to latest minor versions The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.4, 15.8, 14.13, 13.16, and 12.20. This release fixes 1 security vulnerability and over 55 bugs reported over the last several months. PR: 279671 - make the rc script service jails aware PR: 279536 - remove LLVM max version restriction PR: 278887 - SETENV -> SETENVI for -contrib ports Release notes: https://www.postgresql.org/docs/release/ (cherry picked from commit b4e71c8402d027a49eeddb5b585b591019654bb8) databases/postgresql12-client/Makefile | 6 ++++++ databases/postgresql12-contrib/Makefile | 4 ++-- databases/postgresql12-plperl/Makefile | 6 +++--- databases/postgresql12-plpython/Makefile | 4 ++-- databases/postgresql12-pltcl/Makefile | 4 ++-- databases/postgresql12-server/Makefile | 2 +- databases/postgresql12-server/distinfo | 6 +++--- databases/postgresql12-server/files/postgresql.in | 1 + databases/postgresql13-client/Makefile | 6 ++++++ databases/postgresql13-contrib/Makefile | 4 ++-- databases/postgresql13-plperl/Makefile | 6 +++--- databases/postgresql13-plpython/Makefile | 4 ++-- databases/postgresql13-pltcl/Makefile | 4 ++-- databases/postgresql13-server/Makefile | 2 +- databases/postgresql13-server/distinfo | 6 +++--- databases/postgresql13-server/files/postgresql.in | 1 + databases/postgresql14-client/Makefile | 6 ++++++ databases/postgresql14-contrib/Makefile | 4 ++-- databases/postgresql14-docs/Makefile | 2 +- databases/postgresql14-plperl/Makefile | 6 +++--- databases/postgresql14-plpython/Makefile | 4 ++-- databases/postgresql14-pltcl/Makefile | 4 ++-- databases/postgresql14-server/Makefile | 2 +- databases/postgresql14-server/distinfo | 6 +++--- databases/postgresql14-server/files/postgresql.in | 1 + databases/postgresql15-client/Makefile | 6 ++++++ databases/postgresql15-contrib/Makefile | 4 ++-- databases/postgresql15-docs/Makefile | 2 +- databases/postgresql15-plperl/Makefile | 6 +++--- databases/postgresql15-plpython/Makefile | 4 ++-- databases/postgresql15-pltcl/Makefile | 4 ++-- databases/postgresql15-server/Makefile | 2 +- databases/postgresql15-server/distinfo | 6 +++--- databases/postgresql15-server/files/postgresql.in | 1 + databases/postgresql16-client/Makefile | 6 ++++++ databases/postgresql16-contrib/Makefile | 4 ++-- databases/postgresql16-docs/Makefile | 2 +- databases/postgresql16-plperl/Makefile | 6 +++--- databases/postgresql16-plpython/Makefile | 4 ++-- databases/postgresql16-pltcl/Makefile | 4 ++-- databases/postgresql16-server/Makefile | 15 ++------------- databases/postgresql16-server/distinfo | 6 +++--- databases/postgresql16-server/files/postgresql.in | 1 + 43 files changed, 104 insertions(+), 80 deletions(-)