Thank you.
I have noticed that PostgreSQL 15 requires more shared memory than
PostgreSQL 14.
The diagnose I see in /var/postgresql/logfile is:
ERROR: could not open shared memory segment "/PostgreSQL.4139364318":
No such file or directory
To overcome this I have increased values in /etc/sysctl.conf as follows:
kern.seminfo.semmni=1024
kern.seminfo.semmns=2048
kern.shminfo.shmmax=150000000
kern.shminfo.shmall=591200
kern.shminfo.shmmni=8192
kern.shminfo.shmseg=256
Any suggestions about this?
IMHO it is worth mentioning it in
/usr/local/share/doc/pkg-readmes/postgresql-server
Blessings.
El 2023-02-09 11:54, Jeremy Evans escribió:
This updates to PostgreSQL 15.2, released today. Release announcement:
https://www.postgresql.org/about/news/postgresql-152-147-1310-1214-and-1119-released-2592/
One security issue, CVE-2022-41862: Client memory disclosure when
connecting, with Kerberos, to modified server. Is there anyone running
PostgreSQL clients on OpenBSD using Kerberos authentication and
connecting to potentially untrusted servers?
No problems in my testing on amd64. I plan to commit in a couple days
unless I hear objections.
Thanks,
Jeremy
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.292
diff -u -p -r1.292 Makefile
--- Makefile 16 Nov 2022 02:59:22 -0000 1.292
+++ Makefile 9 Feb 2023 15:56:11 -0000
@@ -5,7 +5,7 @@ COMMENT-contrib=PostgreSQL RDBMS contrib
COMMENT-plpython=Python procedural language for PostgreSQL
COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous
version
-VERSION= 15.1
+VERSION= 15.2
PREV_MAJOR= 14
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.95
diff -u -p -r1.95 distinfo
--- distinfo 16 Nov 2022 02:59:22 -0000 1.95
+++ distinfo 9 Feb 2023 15:56:28 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-15.1.tar.gz) =
6izwWahYgmVLmJrNB+3BIYMxZKMDQPruDTYVz3BY5mw=
-SIZE (postgresql-15.1.tar.gz) = 29778341
+SHA256 (postgresql-15.2.tar.gz) =
7M0gjz50Eq17xMZI7Mh+CqUU4CwkpI9xv55GkQvyhMo=
+SIZE (postgresql-15.2.tar.gz) = 29811750
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.25
diff -u -p -r1.25 PLIST-contrib
--- pkg/PLIST-contrib 16 Nov 2022 02:59:23 -0000 1.25
+++ pkg/PLIST-contrib 9 Feb 2023 16:05:51 -0000
@@ -183,6 +183,7 @@ share/postgresql/extension/pageinspect--
share/postgresql/extension/pageinspect--1.7--1.8.sql
share/postgresql/extension/pageinspect--1.8--1.9.sql
share/postgresql/extension/pageinspect--1.9--1.10.sql
+share/postgresql/extension/pageinspect--1.10--1.11.sql
share/postgresql/extension/pageinspect.control
share/postgresql/extension/pg_buffercache--1.0--1.1.sql
share/postgresql/extension/pg_buffercache--1.1--1.2.sql
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.108
diff -u -p -r1.108 PLIST-docs
--- pkg/PLIST-docs 16 Nov 2022 02:59:23 -0000 1.108
+++ pkg/PLIST-docs 9 Feb 2023 16:06:27 -0000
@@ -717,6 +717,7 @@ share/doc/postgresql/html/regress-varian
share/doc/postgresql/html/regress.html
share/doc/postgresql/html/release-15.html
share/doc/postgresql/html/release-15-1.html
+share/doc/postgresql/html/release-15-2.html
share/doc/postgresql/html/release-prior.html
share/doc/postgresql/html/release.html
share/doc/postgresql/html/replication-origins.html
--
Dios, gracias por tu amor infinito.
--
Vladimir Támara Patiño. http://vtamara.pasosdeJesus.org/
http://www.pasosdejesus.org/dominio_publico_colombia.html
