CVE and update status of the FreeBSD ports tree3,864 unaddressed CVEs in 671 portsAll times are CET
Port details

databases/postgresql15-server 15.19

PostgreSQL is the most advanced open-source database available anywhere

Port info

Maintainer
pgsql@FreeBSD.org
Packages
latest: 15.19
Upstream
up to date
Last update
to 15.19 · 60c44ec8a9
Quarterly
2026Q4: 15.19
WWW
https://www.postgresql.org/
Links
cgit · VuXML

Install

Package
# pkg install postgresql15-server
installs 15.19 from latest; from quarterly (2026Q4) 15.19
Port
# cd /usr/ports/databases/postgresql15-server && make install clean
# make -C /usr/ports/databases/postgresql15-server config  # change options first
Size
13 MiB download · 44 MiB installed
Depends on
archivers/liblz4 1.10.0_2,1, archivers/zstd 1.5.7_2, databases/postgresql15-client 15.19, devel/gettext-runtime 1.0_1, devel/icu 76.1,1, devel/llvm19 19.1.7_4, textproc/libxml2 2.15.4
License
PostgreSQL
Creates
user postgres, group postgres
Options
7 of 14 on in the package: DOCS LLVM LZ4 NLS SSL XML ZSTD
Show the 7 options that are off
DEBUG DTRACE GSSAPI LDAP OPTIMIZED_CFLAGS PAM TZDATA
pkg-message
Shown after installing
For procedural languages and postgresql functions, please note that
you might have to update them when updating the server.

If you have many tables and many clients running, consider raising
kern.maxfiles using sysctl(8), or reconfigure your kernel
appropriately.

The port is set up to use autovacuum for new databases, but you might
also want to vacuum and perhaps backup your database regularly. There
is a periodic script, /usr/local/etc/periodic/daily/502.pgsql, that
you may find useful. You can use it to backup and perform vacuum on all
databases nightly. Per default, it performs `vacuum analyze'. See the
script for instructions. For autovacuum settings, please review
~postgres/data/postgresql.conf.

If you plan to access your PostgreSQL server using ODBC, please
consider running the SQL script /usr/local/share/postgresql/odbc.sql
to get the functions required for ODBC compliance.

Please note that if you use the rc script,
/usr/local/etc/rc.d/postgresql, to initialize the database, unicode
(UTF-8) will be used to store character data by default.  Set
postgresql_initdb_flags or use login.conf settings described below to
alter this behaviour. See the start rc script for more info.

To set limits, environment stuff like locale and collation and other
things, you can set up a class in /etc/login.conf before initializing
the database. Add something similar to this to /etc/login.conf:
---
postgres:\
	:lang=en_US.UTF-8:\
	:setenv=LC_COLLATE=C:\
	:tc=default:
---
and run `cap_mkdb /etc/login.conf'.
Then add 'postgresql_login_class="postgres"' to /etc/rc.conf, or
set it as the postgres user's login class in /etc/passwd.

======================================================================

To use PostgreSQL, enable it in rc.conf using

  sysrc postgresql_enable=yes

To initialize the database, run

  service postgresql initdb

You can then start PostgreSQL by running:

  service postgresql start

For postmaster settings, see ~postgres/data/postgresql.conf

NB. FreeBSD's PostgreSQL port logs to syslog by default
    See ~postgres/data/postgresql.conf for more info

NB. If you're not using a checksumming filesystem like ZFS, you might
    wish to enable data checksumming. It can be enabled during
    the initdb phase, by adding the "--data-checksums" flag to
    the postgresql_initdb_flags rcvar. Otherwise you can enable it later by
    using pg_checksums.  Check the initdb(1) manpage for more info
    and make sure you understand the performance implications.

======================================================================

SECURITY ADVICE

If upgrading from a version 15.x < 15.7:
A security vulnerability was found in the system views pg_stats_ext
and pg_stats_ext_exprs, potentially allowing authenticated database
users to see data they shouldn't.  If this is of concern in your
installation, run the SQL script /usr/local/share/postgresql/fix-CVE-2024-4317.sql
for each of your databases. For details, see
https://www.postgresql.org/support/security/CVE-2024-4317/

Packages by version and architecture

latest

FreeBSD versionamd64aarch64i386
FreeBSD 1615.1915.19–
FreeBSD 1515.1915.19–
FreeBSD 1415.1915.1915.19

quarterly (2026Q4)

FreeBSD versionamd64aarch64i386
FreeBSD 1515.1915.19–
FreeBSD 1415.1915.1915.19

version as in the ports tree (latest) or the most common one (quarterly) · different version · ✗ not built · – no packages for this platform. Package sets that have not been rebuilt for 60 days are left out.

Unaddressed and VuXML only (0)

No unaddressed CVE and nothing reported by pkg audit for the packaged version 15.19.

Fixed (34)

Show 34 fixed
VuXML entries whose affected range the packaged version has left, plus CVEs from the last 90 days that this version is already past (fixed by update).
CVECVSSPublishedDescription
CVE-2026-193858.82026-08-13Heap buffer overflow in PostgreSQL pg_dump of long function transform lists allows an object creator to execute arbitrary code as the operating system user running pg_du…
CVE-2026-184088.82026-08-13Untrusted data inclusion in pg_dump in PostgreSQL allows a malicious superuser of the origin server to inject arbitrary code for restore-time execution as the client ope…
CVE-2026-162398.82026-08-13Type confusion in PostgreSQL "portal"/cursor lifecycle allows a user to execute arbitrary code as the operating system user running the database, via re-creation of a cu…
CVE-2026-162388.82026-08-13Type confusion in PostgreSQL pg_restore_attribute_stats() allows an object creator to execute arbitrary code as the operating system user running the database, via confl…
CVE-2026-157428.82026-08-13Integer wraparound in PostgreSQL fuzzystrmatch allows a user to direct writes to a huge range of addresses, executing arbitrary code as the operating system user running…
CVE-2026-146808.82026-08-13Type confusion with PostgreSQL "internal" data type arguments allows any user to execute arbitrary code as the operating system user running the database, via calls to f…
CVE-2026-157418.82026-08-13SQL injection in PostgreSQL EXTRACT() deparse allows an object owner to execute arbitrary SQL as a superuser via a hostile object definition. Attacks affect expression …
CVE-2026-146778.82026-08-13Integer wraparound in PostgreSQL 32-bit builds of pltcl and plperl allows an object creator to cause the server to undersize an allocation and write out-of-bounds via cr…
CVE-2026-146698.82026-08-13Heap buffer overflow in PostgreSQL to_char(timestamptz) allows the party choosing the timezone to execute arbitrary code as the operating system user running the databas…
CVE-2026-146708.82026-08-13Heap buffer overflow in PostgreSQL plperl return of a tied hash allows the function owner to execute arbitrary code as the operating system user running the database, vi…
CVE-2026-146718.82026-08-13Type confusion in PostgreSQL module "refint" allows an object creator to execute arbitrary code as the operating system user running the database. The fix for this emer…
CVE-2026-146628.82026-08-13Integer wraparound in PostgreSQL tsvector and tsquery data type functions allows an unprivileged database user to cause the server to undersize an allocation and write o…
CVE-2026-146648.82026-08-13Heap buffer overflow in PostgreSQL regexp allows the query author to execute arbitrary code as the operating system user running the database, via text that would not pa…
CVE-2026-146798.22026-08-13Stack buffer overflow in PostgreSQL argument name matching allows an object creator to achieve unknown impacts via OUT parameter count. The attack can write only 0x0 an…
CVE-2026-64648.12026-08-13Untrusted data inclusion in PostgreSQL psql COPY may allow a server administrator to elicit execution of data lines as psql commands, via error injection. If the "COPY …
CVE-2026-146688.12026-08-13Type confusion regarding input of PostgreSQL ctid data type selectivity estimator allows an object creator to view a calculation derived from the value of an arbitrary 4…
CVE-2026-64717.22026-08-13Missing authorization in PostgreSQL logical decoding allows a non-superuser holding REPLICATION privilege to dlopen any file visible to the operating system account runn…
CVE-2026-146636.52026-08-13Cleartext storage in PostgreSQL pgcrypto disabled ciphers allows a user to recover cleartext, via direct observation of the faulty ciphertext. The OpenSSL version and O…
CVE-2026-146725.32026-08-13Observable response discrepancy in PostgreSQL SCRAM authentication allows an unauthenticated user to test the existence of a user via observing the SCRAM iteration count…
CVE-2026-64704.32026-08-13Missing authorization in PostgreSQL DDL commands allows an object creator to achieve denial of service against ALTER and DROP of the type, via creating a dependency on t…
CVE-2026-180244.32026-08-13Buffer over-read in PostgreSQL ascii() SQL function allows a user to disclose up to 3 bytes after the end of a specific allocation, via a crafted text value. This is th…
CVE-2026-146784.32026-08-13Buffer over-read in PostgreSQL pg_trgm index picksplit function reads past end of a heap buffer. This might allow a table maintainer to infer limited memory values, via…
CVE-2026-146664.22026-08-13Incomplete tracking in PostgreSQL of changes to role membership, role attributes, and database ownership allows a query to continue using cached row-level security polic…
CVE-2026-64693.82026-08-13Incorrect ownership assignment in PostgreSQL ALTER TABLE ALTER TYPE command reassigns ownership of dependent statistics objects to the current user. This wrongly allows…
CVE-2026-162413.82026-08-13Integer underflow in PostgreSQL ECPG allows a database server administrator to achieve temporary denial of service against the ECPG client via sending a bytea value lack…
CVE-2026-146733.82026-08-13Untrusted search path in PostgreSQL amcheck allows a grantee of amcheck function EXECUTE privilege to execute arbitrary functions as the owners of expression indexes tha…

Problem reports (1) · open in Bugzilla, most recently changed first

PRSummaryStatusChanged
279713maintainer-feedback? databases/postgresql15-server not working on armv7New2025-11-12

Commits (53)

Palle Girgensohn (girgen) · 15.b1_1
postgresql??-server: fix regression in the rc script

The rc script was converted to use a SUB_LIST variable, but I failed to
introduce the variable correctly in the Makefile. [1]

The plist for postgresql15-server was incorrect. Fixed this as well.

PR:	264097 [1]
9230d75a82
Palle Girgensohn (girgen) · 15.b1
databases/postgresql??-server: Remove restriction on LLVM version

PostgreSQL now builds with LLVM version 14. See:
https://github.com/postgres/postgres/commit/d9f7ad54e552262ee0090e88d5abd3e04fcdeac8

Submitted by: tmunro@
1e19f00e5e
Palle Girgensohn (girgen) · 15.b1
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
5b11f47f0d