On 2026/11/12 18:49, Mark Patruck wrote: > Update to databases/postgresql 18.7 released today fixing lots of > high scored CVEs. > > Overview CVEs: > https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/ > > Changelog: > https://www.postgresql.org/docs/18/release-18-7.html#RELEASE-18-7-CHANGES > > > I didn't spot any issues with databases/timescaledb and net/zabbix, > but especially when coming from older versions pay attention to > > https://www.postgresql.org/docs/18/release-18-7.html#RELEASE-18-7-MIGRATION
I still have this in my tree from when we bumped the semaphore limits in the kernel, maybe worth incorporating? (this was pre-8.0 so can just be merged straight into -stable as well). Index: pkg/README-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/README-server,v diff -u -p -r1.42 README-server --- pkg/README-server 7 Aug 2026 08:49:05 -0000 1.42 +++ pkg/README-server 12 Nov 2026 17:56:08 -0000 @@ -56,20 +56,10 @@ Restart PostgreSQL to allow these change Tuning for busy servers ======================= -The default sizes in the GENERIC kernel for SysV semaphores are not -large enough for PostgreSQL. Adding the following in /etc/sysctl.conf -should allow PostgreSQL to start: - - kern.seminfo.semmni=256 - kern.seminfo.semmns=2048 - -While you can start PostgreSQL with smaller limits, it's probably -not wise unless you are very resource constrained. - -You may also want to tune the max_connections value in the -postgresql.conf file to increase the number of connections to the -backend. However, for busy servers with many connections, these -limits may need to be increased further. +You may want to tune the max_connections value in the postgresql.conf +file to increase the number of connections to the backend. However, +for busy servers with many connections, other limits may need to be +increased to accommodate this. By default, the _postgresql user, and so the postmaster and backend processes run in the login(1) class of "postgresql". On a busy server, @@ -77,8 +67,21 @@ it may be advisable to tune resources, s descriptors (used for network connections as well as files), possibly more memory, etc. -The capability database file is located at /etc/login.conf.d/postgresql +These can be changed by editing the capability database file located at +/etc/login.conf.d/postgresql +The default sizes in the GENERIC kernel for SysV semaphores may also +need increasing if a very high number of PostgreSQL processes are +required, or if other applications on the system also require +semaphores. Adding the following in /etc/sysctl.conf should be +sufficient for nearly any PostgreSQL use: + + kern.seminfo.semmni=256 + kern.seminfo.semmns=2048 + +To calculate minimal required values for your configuration, consult +https://www.postgresql.org/docs/${V_MAJOR}/kernel-resources.html + Upgrade Howto (for a major upgrade) =================================== If you didn't install PostgreSQL by following this README,
