databases/postgresql??-*: Update to latest version The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 18.3, 17.9, 16.13, 15.17, and 14.22. This is an out-of-cycle release that fixes several regressions reported after the last update release. Release notes: https://www.postgresql.org/about/news/postgresql-183-179-1613-1517-and-1422-released-3246/ https://wiki.postgresql.org/wiki/2026-02_Regression_Fixesa6361f4a39
Port details
databases/postgresql14-plperl 14.22
Write SQL functions for PostgreSQL using Perl5
Port info
- Maintainer
- pgsql@FreeBSD.org
- Packages
- latest: 14.24, update to 14.22 not built yet
- Upstream
- up to date
- Last update
- to 14.22 · a6361f4a39
- Quarterly
- 2026Q4: 14.24
- WWW
- https://www.postgresql.org/
- Links
- cgit · VuXML
Install
- Package
# pkg install postgresql14-plperlinstalls 14.24 fromlatest; fromquarterly(2026Q4) 14.24- Port
# cd /usr/ports/databases/postgresql14-plperl && make install clean- Size
- 147 KiB download · 662 KiB installed
- Depends on
- databases/postgresql14-server 14.24, devel/readline 8.3.6, lang/perl5.42 5.42.3
- License
- PostgreSQL
- pkg-message
Shown after installing
PL/Perl has been installed. Check the createlang(l) manpage for more info. You can install PL/Perl as trusted or untrusted, by using either "createlang plperl" or "createlang plperlu".
Packages by version and architecture
latest
| FreeBSD version | amd64 | aarch64 | i386 |
|---|---|---|---|
| FreeBSD 16 | 14.24 | 14.24 | – |
| FreeBSD 15 | 14.24 | 14.24 | – |
| FreeBSD 14 | 14.24 | 14.24 | 14.24 |
quarterly (2026Q4)
| FreeBSD version | amd64 | aarch64 | i386 |
|---|---|---|---|
| FreeBSD 15 | 14.24 | 14.24 | – |
| FreeBSD 14 | 14.24 | 14.24 | 14.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 (27)
Show 27 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).
| CVE | CVSS | Published | Description |
|---|---|---|---|
| CVE-2026-19385 | 8.8 | 2026-08-13 | Heap 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-18408 | 8.8 | 2026-08-13 | Untrusted 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-16239 | 8.8 | 2026-08-13 | Type 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-16238 | 8.8 | 2026-08-13 | Type 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-15742 | 8.8 | 2026-08-13 | Integer 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-14680 | 8.8 | 2026-08-13 | Type 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-15741 | 8.8 | 2026-08-13 | SQL 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-14677 | 8.8 | 2026-08-13 | Integer 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-14669 | 8.8 | 2026-08-13 | Heap 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-14670 | 8.8 | 2026-08-13 | Heap 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-14671 | 8.8 | 2026-08-13 | Type 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-14662 | 8.8 | 2026-08-13 | Integer 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-14664 | 8.8 | 2026-08-13 | Heap 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-14679 | 8.2 | 2026-08-13 | Stack 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-6464 | 8.1 | 2026-08-13 | Untrusted 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-14668 | 8.1 | 2026-08-13 | Type 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-6471 | 7.2 | 2026-08-13 | Missing 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-14663 | 6.5 | 2026-08-13 | Cleartext 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-14672 | 5.3 | 2026-08-13 | Observable 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-6470 | 4.3 | 2026-08-13 | Missing 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-18024 | 4.3 | 2026-08-13 | Buffer 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-14678 | 4.3 | 2026-08-13 | Buffer 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-14666 | 4.2 | 2026-08-13 | Incomplete 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-6469 | 3.8 | 2026-08-13 | Incorrect ownership assignment in PostgreSQL ALTER TABLE ALTER TYPE command reassigns ownership of dependent statistics objects to the current user. This wrongly allows… |
| CVE-2026-16241 | 3.8 | 2026-08-13 | Integer 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-14673 | 3.8 | 2026-08-13 | Untrusted 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 (0) · open in Bugzilla, most recently changed first
None.
Commits (5)
databases/postgresql{13,14,15,16,17,18}-*: Multiple fixes
- Strip shared library and binary executable
- Fix stage-qa
- Bump PORTREVISION for package change
postgresql{13,14,15,16,17,18}-server:
- Clean up Makefile: Remove unnecessary ";\"
- Sort PLIST: share/locale comes before DATADIR (share/postgresql)
postgresql{17,18}-plperl:
- Remove duplicate USES=perl5
- Add missing USE_PERL5=run
from postgresql{17,18}-plperl build log:
====> Running Q/A tests (stage-qa)
Error: /usr/local/lib/postgresql/bool_plperl.so is linked to /usr/local/lib/perl5/5.40/mach/CORE/libperl.so.5.40 from lang/perl5.40 but it is not declared as a dependency
PR: 290587
Approved by: girgena626924cf2databases/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/b4e71c8402
databases: remove 'Created by' lines A big Thank You to the original contributors of these ports: * "Choe, Cheng-Dae" whitekid * "Mahdi Mokhtari <mokhi64@gmail.com>" * "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de> * <hvo.pm@xs4all.nl> * <jsmith@resonatingmedia.com> * <ports@c0decafe.net> * Aaron Dalton <aaron@FreeBSD.org> * Adam Weinberger <adamw@FreeBSD.org> * Ade Lovett <ade@FreeBSD.org> * Akinori MUSHA aka knu <knu@idaemons.org> * Alan Snelson <Alan@Wave2.org> * Aldis Berjoza <graudeejs@gmail.com> * Alessando Sagratini <ale_sagra@hotmail.com> * Alex Dupre <ale@FreeBSD.org> * Alex Samorukov <samm@freebsd.org> * Alexander Logvinov <ports@logvinov,com> * Alexander Logvinov <ports@logvinov.com> * Alexander Nedotsukov <bland@FreeBSD.org> * Alexander Novitsky * Alexander Zhuravlev <zaa@zaa.pp.ru> * Alexey Degtyarev <alexey@renatasystems.org> * Alexey Dokuchaev <danfe@FreeBSD.org> * Anders Nordby <anders@fix.no> * Andrei Antoukh <niwi@niwi.be> * Andrew McNaughton <andrew@scoop.co.nz> * Andrew Pantyukhin <infofarmer@FreeBSD.org> * Andrey Kostenko <andrey@kostenko.name> * Andrey Simonenko * Andrey Zakhvatov * Anes Mukhametov <anes@anes.su> * Anton Berezin <tobez@FreeBSD.org> * Anton Berezin <tobez@tobez.org> * Antonio Carlos Venancio Junior (<antonio@inf.ufsc.br>) * Antonio Carlos Venancio Junior (<antonio@php.net>) * Autrijus Tang <autrijus@autrijus.org> * Babak Farrokhi <farrokhi@FreeBSD.org> * Bartek Rutkowski <r@robakdesign.com> * Bernard Spil <brnrd@FreeBSD.org> * Brent J. Nordquist <bjn@visi.com> * Cezary Morga <cm@therek.net> * Cheng-Lung Sung <clsung@FreeBSD.org> * Choe, Cheng-Dae * Chris D. Faulhaber <jedgar@FreeBSD.org> * Chris Larsen <darth@vader.dk> * Damian Gerow <dgerow@afflictions.org> * Daniel O'Connor * Daniel Wijnands <daniel@itxl.nl> * Dave Green <dg@fastmail.co.uk> * David Thiel <lx@FreeBSD.org> * Davíð Steinn Geirsson <david@isnic.is> * Denis Generalov <gd.workbox@gmail.com> * Denis Generalov <gd@rambler-co.ru> * Denis Shaposhnikov <dsh@bamus.cz> * Dermot Tynan <dtynan@kalopa.com> * Dmitry Liakh <dliakh@ukr.net> * Dmitry Sivachenko <demon@FreeBSD.org> * Dmitry Sivachenko <dima@Chg.RU> * Dmitry Sivachenko <mitya@yandex-team.ru> * Domas Mituzas <midom@dammit.lt> * Dominic Mitchell * Don Owens <don@regexguy.com> * Dryice Dong Liu <dryice@dryice.name> * Edwin Groothuis (edwin@mavetju.org) * Eric Freeman <freebsdports@chillibear.com> * Espen Tagestad <espen@tagestad.no> * Espen Volden aka voldern <voldern@hoeggen.net> * Evan Sarmiento <bsdports@wayfair.com> * Fernan Aguero <fernan@iib.unsam.edu.ar> * Frank Wall <fw@moov.de> * Ganbold Tsagaankhuu <ganbold@FreeBSD.org> * Gary Palmer <gpalmer@FreeBSD.org> * Gea-Suan Lin <gslin@gslin.org> * Geraud CONTINSOUZAS <geraud@gcu.info> * Gerrit Beine <tux@pinguru.net> * Greg Larkin <glarkin@FreeBSD.org> * Grzegorz Blach <gblach@FreeBSD.org> * Hansjoerg Pehofer <hansjoerg.pehofer@uibk.ac.at> * Henk van Oers <hvo.pm@xs4all.nl> * Henrik Hodne <henrik@hodne.io> * Hiroyuki Hanai <hanai@FreeBSD.org> * Horia Racoviceanu <horia@racoviceanu.com> * Hye-Shik Chang * Hye-Shik Chang <perky@python.or.kr> * Ilia Chipitsine <ilia@jane.cgu.chel.su> * Ivan Voras <ivoras@FreeBSD.org> * J.F. Dockes * Jaap Boender <jaapb@kerguelen.org> * Jake Smith <jake@xz.cx> * James FitzGibbon <jfitz@FreeBSD.org> * Janos Mohacsi <janos.mohacsi@bsd.hu> * Janos.Mohacsi@bsd.hu * Jason Helfman <jgh@FreeBSD.org> * Jens Rehsack <rehsack@liwing.de> * Jeremy Chadwick <koitsu@FreeBSD.org> * Jev Björsell <ports@ecadlabs.com> * Jim Ohlstein <jim@ohlste.in> * Jin-Shan Tseng <tjs@cdpa.nsysu.edu.tw> * Joe Horn <joehorn@gmail.com> * Joe Marcus Clarke <marcus@FreeBSD.org> * Johannes Meixner <johannes@perceivon.net> * John Chen <johnpupu@gmail.com> * John Marino <marino@FreeBSD.org> * John Merryweather Cooper * John Merryweather Cooper et al * Jon Nistor <nistor@snickers.org> * Jonathan Weiss (<jw@innerewut.de>) * Jose Jachuf <jjachuf@gmail.com> * Joshua D. Abraham <jabra@ccs.neu.edu> * Jov <amutu@amutu.com> * Jov amutu@amutu.com * Jui-Nan Lin <jnlin@freebsd.cs.nctu.edu.tw> * Julien Laffaye <kimelto@gmail.com> * Jyun-Yan You <jyyou@cs.nctu.edu.tw> * Keith Gaughan <k@sterechro.me> * Kevin Bowling <kbowling@freebsd.org> * Kimo <kimor79@yahoo.com> * Kimura Fuyuki <fuyuki@nigredo.org> * Koop Mast <kwm@FreeBSD.org> * Lars Balker Rasmussen <lbr@FreeBSD.org * Lars Balker Rasmussen <lbr@FreeBSD.org> * Lars Eggert <larse@isi.edu> * Lars Thegler <lars@thegler.dk> * Lars Thegler <lth@FreeBSD.org> * Li-Wen Hsu <lwhsu@FreeBSD.org> * Loïc BARTOLETTI * Loïc BARTOLETTI <lbartoletti@FreeBSD.org> * Lubomir Marinov <lubomir_m@abv.bg> * Mahdi Mokhtari <mokhi64@gmail.com> * Mahlon E. Smith <mahlon@martini.nu> * Marc G. Fournier <scrappy@FreeBSD.org> * Mark Felder <feld@FreeBSD.org> * Markus Brueffer <markus@FreeBSD.org> * Martin Matuska <martin@matuska.org> * Martin Matuska <mm@FreeBSD.org> * Martin Wilke <miwi@FreeBSD.org> * Mathieu Arnold <m@absolight.net> * Matthew Seaman * Matthias Andree <mandree@FreeBSD.org> * Matthias Fechner <mfechner@FreeBSD.org> * Matthias Petermann <matthias@petermann-it.de> * Max Khon * Max Khon <fjoe@FreeBSD.org> * Michael Johnson <ahze@FreeBSD.org> * Michael Johnson <ahze@ahze.net> * Michael Winking <mwfp@foldl.net> * Mikael URANKAR and Loïc BARTOLETTI * Mike Carlson (carlson39@llnl.gov) * Mikhail T. <michael@fun-box.ru> * Mikhail Teterin * Mikhail Teterin <mi@aldan.algebra.com> * Mikolaj Golub <trociny@FreeBSD.org> * Mirko Zinn <mail@derzinn.de> * Mohammad S. Babaei <info@babaei.net> * Muhammad Moinur Rahman <bofh@FreeBSD.org> * Nick Hibma <n_hibma@freebsd.org> * Nick Hilliard <nick@foobar.org> * Nick Sayer <nsayer@FreeBSD.org> * Nicola Vitale <nivit@FreeBSD.org> * Nicolas Embriz <nbari@tequila.io> * Nicolas de Bari Embriz <nbari@dalmp.com> * Oleg Sharoiko <os@rsu.ru> * Olexander Melnyk <olexander.v.melnyk@gmail.com> * Oliver Eikemeier <eikemeier@fillmore-labs.com> * Olivier Duchateau <duchateau.olivier@gmail.com> * Palle Girgensohn <girgen@FreeBSD.org> * Palle Girgensohn <girgen@partitur.se> * Palle Girgensohn <girgen@pingpong.net> * Parv <parv@pair.org> * Pete Fritchman <petef@databits.net> * Peter Avalos <pavalos@theshell.com> * Philip M. Gollucci * Philip M. Gollucci <philip@p6m7g8.com> * Philip Stoev <philip.stoev@galeracluster.com> * Pierre-Emmanuel Andre <pea@raveland.org> * Pietro Cerutti <gahr@FreeBSD.org> * Piotr Kubaj <pkubaj@anongoth.pl> * Po-Chuan Hsieh <sunpoet@FreeBSD.org> * Qing Feng <qingfeng@douban.com> * Quinton Dolan <q@onthenet.com.au> * Radim Kolar * Rainer Hurling <rhurlin@gwdg.de> * Rick Miller * Robert Kruus <rob.kruus@gmail.com> * Rod Taylor <ports@rbt.ca> * Roland van Laar <roland@micite.net> * Rong-En Fan <rafan@FreeBSD.org> * Roy Boerner * Rozhuk Ivan <rozhuk.im@gmail.com> * Rusty Nejdl * Ryan Steinmetz <rpsfa@rit.edu> * Ryan Steinmetz <zi@FreeBSD.org> * Ryan T. Dean <rtdean@cytherianage.net> * Sam Lawrance <boris@brooknet.com.au> * Scott McWhirter <scott@surreytech.co.uk> * Seamus Venasse <svenasse@polaris.ca> * Sean Chittenden <seanc@FreeBSD.org> * Sergei Kolobov <sergei@kolobov.com> * Sergei Vyshenski <svysh.fbsd@gmail.com> * Sergey A. Osokin <osa@FreeBSD.org.ru> * Sergey A. Osokin <osa@FreeBSD.org> * Sergey Matveychuk <sem@FreeBSD.org> * Sergey Skvortsov <skv@FreeBSD.org> * Sergey Skvortsov <skv@protey.ru> * Sevan Janiyan <venture37@geeklan.co.uk> * Sheldon Hearn <sheldonh@FreeBSD.org> * Stanislav Svirid <count@211.ru> * Stefan Schmidt <stefan.schmidt@stadtbuch.de> * Steve Wills <swills@FreeBSD.org> * Steve Wills <swills@freebsd.org> * Steven Kreuzer <skreuzer@FreeBSD.org> * Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org> * Sunpoet Po-Chuan Hsieh <sunpoet@sunpoet.net> * T. William Wells <bill@twwells.com> * TAKATSU Tomonari <tota@FreeBSD.org> * Thierry Thomas (<thierry@pompo.net>) * Thomas Gellekum <tg@FreeBSD.org> * Timur I. Bakeyev <bat@cpan.org> * Tom Judge <tj@FreeBSD.org> * Torsten Zuehlsdorff <ports@toco-domains.de> * Torsten Zuhlsdorff <ports@toco-domains.de> * Toshiya Saitoh (<toshiya@saitoh.nu>) * Tsung-Han Yeh <snowfly@yuntech.edu.tw> * Vasil Dimov <vd@FreeBSD.org> * Veniamin Gvozdikov <vg@FreeBSD.org> * Vladimir Timofeev <vovkasm@gmail.com> * Wen Heping * Wen Heping <wen@FreeBSD.org> * Wen Heping <wenheping@gmail.com> * Wen heping <wenheping@gmail.com> * William Grzybowski <wg@FreeBSD.org> * Xin Li <delphij@FreeBSD.org> * Yarema <yds@CoolRat.org> * Yarema <yds@Necessitu.de> * Yen-Ming Lee <leeym@FreeBSD.org> * Ying-Chieh Liao <ijliao@FreeBSD.org> * Yoichi NAKAYAMA <yoichi@FreeBSD.org> * Yuri Victorovich <yuri@rawbw.com> * Zach Thompson <hideo@lastamericanempire.com> * Zach Thompson <lin-chi@lastamericanempire.com> * ache@FreeBSD.org * alfred * alp@sfedu.ru * andrew@scoop.co.nz * andrey@kostenko.name * chinsan * chinsan <chinsan.tw@gmail.com> * clive * clive@FreeBSD.org * clsung@dragon2.net * dcf@aracnet.com * elvstone@gmail.com * erikhb@bgnett.no * erwin@FreeBSD.org * gahr * ijliao * ijlioa * ivoras * johnpupu <johnpupu@gmail.com> * kirk@daycos.com * kuriyama * lbartoletti <lbartoletti@FreeBSD.org> * loïc bartoletti <lbartoletti@FreeBSD.org> * mharo@FreeBSD.org * michael johnson <ahze@ahze.net> * milki <milki@rescomp.berkeley.edy> * mm@FreeBSD.org * nbm * nectar@FreeBSD.org * nork@FreeBSD.org * nork@cityfujisawa.ne.jp * olevole@olevole.ru * proler@gmail.com * sergey@migsoft.com.ua * sobomax * spam@rm-rf.kiev.ua * stas * tobez * tremere@cainites.net * vanilla * vanilla@ * wen@FreeBSD.org * wenheping<wenheping@gmail.com> * wolman@cs.washington.edu * # Created by Kevin Bowling <kbowling@FreeBSD.org> * # Created by Matthias Fechner <mfechner@FreeBSD.org> With hat: portmgrd076ad94e2
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