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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details
postgresql95-plpython Module for using Python to write SQL functions
9.5.25 databases Deleted on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 9.5.25Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: PostgreSQL-9.5 has reached end-of-life
Expired This port expired on: 2021-06-13
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-01-07 19:59:11
Last Update: 2021-06-13 10:50:22
Commit Hash: a3da90c
Also Listed In: python
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. WWW: https://www.postgresql.org/
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 (34 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql95-plpython-9.5.25/catalog.mk
  2. /usr/local/share/licenses/postgresql95-plpython-9.5.25/LICENSE
  3. /usr/local/share/licenses/postgresql95-plpython-9.5.25/PostgreSQL
  4. include/postgresql/server/plpy_util.h
  5. include/postgresql/server/plpython.h
  6. share/doc/postgresql/README-plpython
  7. @comment lib/postgresql/plpython2.so
  8. lib/postgresql/plpython3.so
  9. @comment share/postgresql/extension/plpython2u--1.0.sql
  10. @comment share/postgresql/extension/plpython2u--unpackaged--1.0.sql
  11. @comment share/postgresql/extension/plpython2u.control
  12. share/postgresql/extension/plpython3u--1.0.sql
  13. share/postgresql/extension/plpython3u--unpackaged--1.0.sql
  14. share/postgresql/extension/plpython3u.control
  15. @comment share/postgresql/extension/plpythonu--1.0.sql
  16. @comment share/postgresql/extension/plpythonu--unpackaged--1.0.sql
  17. @comment share/postgresql/extension/plpythonu.control
  18. lib/postgresql/hstore_plpython3.so
  19. lib/postgresql/ltree_plpython3.so
  20. share/postgresql/extension/hstore_plpython2u--1.0.sql
  21. share/postgresql/extension/hstore_plpython2u.control
  22. share/postgresql/extension/hstore_plpython3u--1.0.sql
  23. share/postgresql/extension/hstore_plpython3u.control
  24. share/postgresql/extension/hstore_plpythonu--1.0.sql
  25. share/postgresql/extension/hstore_plpythonu.control
  26. share/postgresql/extension/ltree_plpython2u--1.0.sql
  27. share/postgresql/extension/ltree_plpython2u.control
  28. share/postgresql/extension/ltree_plpython3u--1.0.sql
  29. share/postgresql/extension/ltree_plpython3u.control
  30. share/postgresql/extension/ltree_plpythonu--1.0.sql
  31. share/postgresql/extension/ltree_plpythonu.control
  32. @owner
  33. @group
  34. @mode
Collapse this list.
Dependency lines:
  • postgresql95-plpython>0:databases/postgresql95-plpython
Conflicts:
CONFLICTS:
  • postgresql9[^5]*
  • postgresql1[0-9]*
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
No installation instructions:
This port has been deleted.
PKGNAME: postgresql95-plpython
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1612956696 SHA256 (postgresql/postgresql-9.5.25.tar.bz2) = 7628c55eb23768a2c799c018988d8f2ab48ee3d80f5e11259938f7a935f0d603 SIZE (postgresql/postgresql-9.5.25.tar.bz2) = 17923796

Expand this list (2 items)

Collapse this list.

SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365 SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952

Collapse this list.


Packages (timestamps in pop-ups are UTC):
postgresql95-plpython
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--9.5.24---9.5.24-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
FreeBSD:15:quarterly--n/a-n/a---
Master port: databases/postgresql95-server
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. postgres : databases/postgresql95-server
  2. python3.8 : lang/python38
  3. gmake>=4.3 : devel/gmake
Runtime dependencies:
  1. postgres : databases/postgresql95-server
  2. python3.8 : lang/python38
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_postgresql95-plpython
USES:
pgsql:9.5 python tar:bzip2 cpe gmake compiler
pkg-message:
For install:
PL/Python has been installed. Check the createlang(l) manpage for more info. You can install PL/Python by using "createlang plpythonu" (it exists as an untrusted language only).
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://ftp.postgresql.org/pub/source/v9.5.25/
Collapse this list.
Port Moves
  • port deleted on 2021-06-13
    REASON: Has expired: PostgreSQL-9.5 has reached end-of-life

Number of commits found: 17

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/postgresql95-server
CommitCreditsLog message
9.5.25
13 Jun 2021 10:50:22
commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1commit hash: a3da90c5e4f183d6a61b55ac6da01974ab575ed1 files touched by this commit
Rene Ladan (rene) search for other commits by this committer
*/*: Remove expired ports:

2021-06-13 databases/postgresql95-client: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-contrib: PostgreSQL-9.5 has reached
end-of-life
2021-06-13 databases/postgresql95-docs: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-pgtcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plperl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plpython: PostgreSQL-9.5 has reached
end-of-life
2021-06-13 databases/postgresql95-pltcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-server: PostgreSQL-9.5 has reached end-of-life
databases/pg_reorg: abandonware only for PostgreSQL 9.5
databases/pgespresso: functionality part of PostgreSQL 9.6 and later
9.5.25
20 May 2021 14:38:55
commit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5dbcommit hash: fccc45e5ff4a8aea150005196c0d4f2cbaeed5db files touched by this commit
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.
9.5.25
07 Apr 2021 08:09:01
commit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455c files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
9.5.25
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
9.5.23
24 Sep 2020 13:33:10
Revision:549921Original commit files touched by this commit
girgen search for other commits by this committer
Welcome PostgreSQL 13

Release notes:	https://www.postgresql.org/about/news/2077/
9.5.22
17 May 2020 20:37:04
Revision:535676Original commit files touched by this commit
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]
9.5.19
08 Aug 2019 15:33:03
Revision:508390Original commit files touched by this commit
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)
9.5.18_1
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
9.5.18
29 Jun 2019 17:35:23
Revision:505361Original commit files touched by this commit
mat search for other commits by this committer
Make sure we don't clobber slave ports' PORTREVISION.
9.5.16
15 Feb 2019 11:02:22
Revision:492989Original commit files touched by this commit
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 11.2, 10.7, 9.6.12,
9.5.16, and 9.4.21. This release changes the behavior in how PostgreSQL
interfaces with `fsync()` and includes fixes for partitioning and over
70 other bugs that were reported over the past three months.

Users should plan to apply this update at the next scheduled downtime.

FreeBSD port adds OPTIONS knob to support LLVM JIT. [1]

Highlight: Change in behavior with fsync()
------------------------------------------

When available in an operating system and enabled in the configuration
file (which it is by default), PostgreSQL uses the kernel function
(Only the first 15 lines of the commit message are shown above View all of this commit message)
9.5.15_2
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
9.5.12
08 May 2018 19:37:25
Revision:469407Original commit files touched by this commit
sunpoet search for other commits by this committer
Update WWW

Approved by:	portmgr (blanket)
9.5.9
24 Sep 2017 18:58:59
Revision:450532Original commit files touched by this commit
girgen search for other commits by this committer
Correct default data directory for postgresql 10

...and make sure not to bump portrevision more than necessary.

POINTED OUT BY: Peter Laursen
9.5.8_1
17 Aug 2017 16:19:01
Revision:448138Original commit files touched by this commit
mat search for other commits by this committer
Fix the PostgreSQL 10 package names.

Most of them were called things like postgresql10beta3-docs-10.b3

With hat:	portmgr
Sponsored by:	Absolight
9.5.5_1
07 Jan 2017 21:42:28
Revision:430839Original commit files touched by this commit
sunpoet search for other commits by this committer
Add more PLIST_SUB to Mk/Uses/python.mk

- Add PYTHON_PYOEXTENSION and PYTHON_SUFFIX
- Add PYTHON2 and PYTHON3
- Respect PYTHON_VERSION
- Rename PYOEXTENSION to PYTHON_PYOEXTENSION

This change would help:
- Build databases/postgresql*-plpython with Python 3
  (It has PLIST issue since bsd.python.mk to Uses/python.mk transition)
- Simplify Makefile

PR:		205807
Differential Revision:	https://reviews.FreeBSD.org/D4758
Exp-run by:	antoine
9.5.3
01 Jul 2016 17:45:51
Revision:417899Original commit files touched by this commit
matthew search for other commits by this committer
Delete the now expired postgresql90 ports.  Upstream support for
postgresql-9.0.x was declared EoL in September 2015.

Summary:
Remove 9.0 from the list of postgresql versions available in ports

Disconnect postgresql90 ports from the build

Remove postgresql90-pgtcl port

Remove postgresql90-client port

Move the master postgreslXY-plperl makefile to postgresql95-plperl/Makefile.

Adjust include lines in other postgresqlXY-plperl ports
(Only the first 15 lines of the commit message are shown above View all of this commit message)
9.5.0
07 Jan 2016 19:58:47
Revision:405482Original commit files touched by this commit
girgen search for other commits by this committer
The PostgreSQL Global Development Group announces the
release of PostgreSQL 9.5.

This release adds UPSERT capability, Row Level Security,
and multiple Big Data features, which will broaden the
user base for the world's most advanced database.
With these new capabilities, PostgreSQL will be
the best choice for even more applications for startups,
large corporations, and government agencies.

Release Notes:
http://www.postgresql.org/docs/current/static/release-9-5.html

What's New in 9.5:
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5

Number of commits found: 17