notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine

Newsfeed changes

The news feed page[s] were not laid out well. Two pages, disjointed information, hard to figure out how to use the optional parameters...

Thankfully, someone told me.

The new page is ready for your review. Please compare these two:

You may also be interested in the Github issue.
Port details
postgresql12-plperl Write SQL functions for PostgreSQL using Perl5
12.22 databases Deleted on this many watch lists=2 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 12.22Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: PostgreSQL-12 is end-of-life
Expired This port expired on: 2024-12-31
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2019-08-08 15:33:17
Last Update: 2025-01-01 12:01:19
Commit Hash: 52ef8f1
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
Also Listed In: perl5
License: PostgreSQL
WWW:
https://www.postgresql.org/
Description:
PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere. Commercial Support is also available. The original Postgres code was the effort of many graduate students, undergraduate students, and staff programmers working under the direction of Professor Michael Stonebraker at the University of California, Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query language to SQL and created a new database system which came to known as Postgres95. Many others contributed to the porting, testing, debugging and enhancement of the Postgres95 code. As the code improved, and 1995 faded into memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (28 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql12-plperl-12.22/catalog.mk
  2. /usr/local/share/licenses/postgresql12-plperl-12.22/LICENSE
  3. /usr/local/share/licenses/postgresql12-plperl-12.22/PostgreSQL
  4. include/postgresql/server/plperl.h
  5. include/postgresql/server/plperl_helpers.h
  6. include/postgresql/server/plperl_system.h
  7. include/postgresql/server/ppport.h
  8. share/postgresql/extension/plperlu--1.0.sql
  9. share/postgresql/extension/plperl.control
  10. share/postgresql/extension/plperl--1.0.sql
  11. share/postgresql/extension/plperlu.control
  12. share/postgresql/extension/plperlu--unpackaged--1.0.sql
  13. share/postgresql/extension/plperl--unpackaged--1.0.sql
  14. share/doc/postgresql/README-plperl
  15. lib/postgresql/plperl.so
  16. lib/postgresql/hstore_plperl.so
  17. lib/postgresql/jsonb_plperl.so
  18. share/postgresql/extension/hstore_plperl--1.0.sql
  19. share/postgresql/extension/hstore_plperl.control
  20. share/postgresql/extension/hstore_plperlu--1.0.sql
  21. share/postgresql/extension/hstore_plperlu.control
  22. share/postgresql/extension/jsonb_plperl--1.0.sql
  23. share/postgresql/extension/jsonb_plperl.control
  24. share/postgresql/extension/jsonb_plperlu--1.0.sql
  25. share/postgresql/extension/jsonb_plperlu.control
  26. @owner
  27. @group
  28. @mode
Collapse this list.
Dependency lines:
  • postgresql12-plperl>0:databases/postgresql12-plperl
Conflicts:
CONFLICTS:
  • postgresql1[^2]*
No installation instructions:
This port has been deleted.
PKGNAME: postgresql12-plperl
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1732004002 SHA256 (postgresql/postgresql-12.22.tar.bz2) = 8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b SIZE (postgresql/postgresql-12.22.tar.bz2) = 21305304

Packages (timestamps in pop-ups are UTC):
postgresql12-plperl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--12.5---12.5-
FreeBSD:13:quarterly--12.16--12.1712.1712.17
FreeBSD:14:latest--12.13--12.15-12.15
FreeBSD:14:quarterly-----12.1712.1712.17
FreeBSD:15:latest--n/a-n/a12.1712.1712.18
Master port: databases/postgresql12-server
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. perl5>=5.36<5.37 : lang/perl5.36
Runtime dependencies:
  1. postgres : databases/postgresql12-server
  2. perl5>=5.36<5.37 : lang/perl5.36
Library dependencies:
  1. libreadline.so.8 : devel/readline
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_postgresql12-plperl
USES:
perl5 readline tar:bzip2 cpe gmake
pkg-message:
For install:
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".
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://ftp.postgresql.org/pub/source/v12.22/
Collapse this list.
Port Moves
  • port deleted on 2025-01-01
    REASON: Has expired: PostgreSQL-12 is end-of-life
  • port moved here from databases/postgresql11-plperl on 2023-12-31
    REASON: Has expired: Security support ended on 2023-11-09

Number of commits found: 7

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql12-server
CommitCreditsLog message
12.22
01 Jan 2025 12:01:19
commit hash: 52ef8f1b17ec559936c569ba036323d7481ad09ccommit hash: 52ef8f1b17ec559936c569ba036323d7481ad09ccommit hash: 52ef8f1b17ec559936c569ba036323d7481ad09ccommit hash: 52ef8f1b17ec559936c569ba036323d7481ad09c files touched by this commit
Rene Ladan (rene) search for other commits by this committer
databases/postgresql12-plperl: Remove expired port

2024-12-31 databases/postgresql12-plperl: PostgreSQL-12 is end-of-life
12.20
08 Aug 2024 13:02:46
commit hash: b4e71c8402d027a49eeddb5b585b591019654bb8commit hash: b4e71c8402d027a49eeddb5b585b591019654bb8commit hash: b4e71c8402d027a49eeddb5b585b591019654bb8commit hash: b4e71c8402d027a49eeddb5b585b591019654bb8 files touched by this commit This port version is marked as vulnerable.
Palle Girgensohn (girgen) search for other commits by this committer
databases/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/
12.11
20 Jul 2022 14:21:07
commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 files touched by this commit This port version is marked as vulnerable.
Tobias C. Berner (tcberner) search for other commits by this committer
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>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
12.7
20 May 2021 14:38:55
commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db files touched by this commit This port version is marked as vulnerable.
Palle Girgensohn (girgen) search for other commits by this committer
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.
12.6
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit This port version is marked as vulnerable.
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
12.3
17 May 2020 20:37:04
Revision:535676Original commit files touched by this commit This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 12.3, 11.8, 10.13,
9.6.18, and 9.5.22.  This release fixes one security issue found in the
PostgreSQL server and over 75 bugs reported over the last three months.

Please plan to update at your earliest convenience.

Update the backup warning text. [1]

Add plpython and plperl libs for hstore, jsonb and ltree for the versions where
they exist. These libs are added to the postgresql??-plpython and -plperl
ports, inspired by [2].

PR:		237910 [1], 245246 [2]
Submitted by:	Francesco [1], Loic Bartoletti [2]
12.b3
08 Aug 2019 15:33:03
Revision:508390Original commit files touched by this commit This port version is marked as vulnerable.
girgen search for other commits by this committer
iThe PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 11.5, 10.10,
9.6.15, 9.5.19, and 9.4.24, as well as the third beta of PostgreSQL 12.
This release fixes two security issues in the PostgreSQL server, two
security issues found in one of the PostgreSQL Windows installers, and
over 40 bugs reported since the previous release.

Users should install these updates as soon as possible.

A Note on the PostgreSQL 12 Beta
================================

In the spirit of the open source PostgreSQL community, we strongly
encourage you to test the new features of PostgreSQL 12 in your database
systems to help us eliminate any bugs or other issues that may exist.
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 7