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

databases/postgresql14-server 14.24

PostgreSQL is the most advanced open-source database available anywhere

Port info

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

Install

Package
# pkg install postgresql14-server
installs 14.24 from latest; from quarterly (2026Q4) 14.24
Port
# cd /usr/ports/databases/postgresql14-server && make install clean
# make -C /usr/ports/databases/postgresql14-server config  # change options first
Size
13 MiB download · 41 MiB installed
Depends on
archivers/liblz4 1.10.0_2,1, databases/postgresql14-client 14.24, 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
6 of 13 on in the package: DOCS LLVM LZ4 NLS SSL XML
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 14.x < 14.12:
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 1614.2414.24–
FreeBSD 1514.2414.24–
FreeBSD 1414.2414.2414.24

quarterly (2026Q4)

FreeBSD versionamd64aarch64i386
FreeBSD 1514.2414.24–
FreeBSD 1414.2414.2414.24

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 14.24.

Fixed (36)

Show 36 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
276443maintainer-feedback? databases/postgresql14-server: rc.conf setting postgresql_env is ignoredNew2026-05-21

Commits (62)

Piotr Kubaj (pkubaj) · 14.1
databases/postgresql14-server: fix build on riscv64

Same issue as other postgresql ports.
55d4835be5
Palle Girgensohn (girgen) · 14.1
databases/postgresql??-*: updated to latest version

This release contains a variety of fixes from the previous version.

A dump/restore is not required for those running the same major version.
However, note that installations using physical replication should
update standby servers before the primary server, as explained in the
release notes.

Also, several bugs have been found that may have resulted in corrupted
indexes, as explained in the next several changelog entries.  If any of
those cases apply to you, it's recommended to reindex possibly-affected
indexes after updating.

This release also mitigates two possible man-in-the-middle attacks.

Security:	2ccd71bd-426b-11ec-87db-6cc21735f730
Release notes:	https://www.postgresql.org/docs/release/14.1/
d3db7630c7
Jan Beich (jbeich) · 14.0_1
devel/icu: update to 70.1

Changes:	https://github.com/unicode-org/icu/releases/tag/release-70-1
Reported by:	GitHub (watch releases)
PR:		258794
Exp-run by:	antoine
f34ece3aa6
Palle Girgensohn (girgen) · 14.0
databases/postgresql14-server: Introducing PostgreSQL-14

PostgreSQL 14 brings a variety of features that help developers and
administrators deploy their data-backed applications. PostgreSQL
continues to add innovations on complex data types, including more
convenient access for JSON and support for noncontiguous ranges of data.
This latest release adds to PostgreSQL's trend on improving high
performance and distributed data workloads, with advances in connection
concurrency, high-write workloads, query parallelism and logical
replication.

Release notes:	https://www.postgresql.org/docs/14/release-14.html
a91450e0e5
Palle Girgensohn (girgen) · 14.r1_2
databases/postgresql14-server: fix openssl dependency

libpq.pc should not require openssl from ports when built with base -lssl

PR:	258760
59611d61d7
Palle Girgensohn (girgen) · 14.r1_1
databases/postgresql14-server: add support for lz4 compression
0edd2574e1
Palle Girgensohn (girgen) · 14.r1
databases/postgresql14: update to 14rc1

Release notes:	https://www.postgresql.org/docs/14/release-14.html
66e70f54f4
Palle Girgensohn (girgen) · 14.b3
databases/postgresql*: update to latest versions

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 13.4, 12.8, 11.13, 10.18, and
9.6.23, as well as the third beta release of PostgreSQL 14. This release closes
one security vulnerability and fixes over 75 bugs reported over the last three
months.

Turn off parallel builds since we continue to struggle with build problems when
it is activated. [1]

Avoid chasing latest LLVM version. [2]

PR:		256466 [1], 256167 [2]
Release notes:	https://www.postgresql.org/docs/release/
Security:	b471130b-fb86-11eb-87db-6cc21735f730
a271b9d5b7
Palle Girgensohn (girgen) · 14.b2_2
databases/postgres14-*: Update to 14.0-beta2

Release notes:	https://www.postgresql.org/developer/beta/
377ebb0c61
Palle Girgensohn (girgen) · 14.b1_2
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
8d831eb43a
Palle Girgensohn (girgen) · 14.b1_1
databases/postgresql14-server: fix data directory

PR:	256125
093fa95e0c
Palle Girgensohn (girgen) · 14.b1
databases/postgresql14-*: Add postgresql 14 beta1 the the ports tree.

Release notes:	https://www.postgresql.org/docs/devel/release-14.html

Also reintroduce parallel builds. Some components, namely plperl,
plpython, pltcl and contrib, fail to build properly when using parallel
builds. Something with static linking using `ar` that fails.
MAKE_JOBS_UNSAFE is set for these ports.
fccc45e5ff