notbugIf you buy from Amazon USA, please support us by using this link.
Port details
postgresql95-plpython Module for using Python to write SQL functions
9.5.16 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: search for ports maintained by this maintainer
Port Added: 2016-01-07 19:59:11
Last Update: 2019-02-15 11:02:22
SVN Revision: 492989
Also Listed In: python
License: PostgreSQL
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.

SVNWeb : Homepage
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (17 items)
  1. /usr/local/share/licenses/postgresql95-plpython-9.5.16/
  2. /usr/local/share/licenses/postgresql95-plpython-9.5.16/LICENSE
  3. /usr/local/share/licenses/postgresql95-plpython-9.5.16/PostgreSQL
  4. include/postgresql/server/plpy_util.h
  5. include/postgresql/server/plpython.h
  6. share/doc/postgresql/README-plpython
  7. lib/postgresql/
  8. @comment lib/postgresql/
  9. share/postgresql/extension/plpython2u--1.0.sql
  10. share/postgresql/extension/plpython2u--unpackaged--1.0.sql
  11. share/postgresql/extension/plpython2u.control
  12. @comment share/postgresql/extension/plpython3u--1.0.sql
  13. @comment share/postgresql/extension/plpython3u--unpackaged--1.0.sql
  14. @comment share/postgresql/extension/plpython3u.control
  15. share/postgresql/extension/plpythonu--1.0.sql
  16. share/postgresql/extension/plpythonu--unpackaged--1.0.sql
  17. share/postgresql/extension/plpythonu.control
  18. Collapse this list.
Dependency lines:
  • postgresql95-plpython>0:databases/postgresql95-plpython
    • postgresql9[^5]*
    • postgresql1[0-9]*
Conflicts Matches:
    There are no Conflicts Matches for this port. This is usually an error.

To install the port: cd /usr/ports/databases/postgresql95-plpython/ && make install clean
To add the package: pkg install postgresql95-plpython

PKGNAME: postgresql95-plpython

There is no flavor information for this port.


TIMESTAMP = 1550095350
SHA256 (postgresql/postgresql-9.5.16.tar.bz2) = a4576c95d4dcee8d4b7835b333d38e909848222e4b87895878bb1c026206e131
SIZE (postgresql/postgresql-9.5.16.tar.bz2) = 17506874
SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365
SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952

Master port: databases/postgresql95-server

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. postgres : databases/postgresql95-server
  2. python2.7 : lang/python27
  3. gmake : devel/gmake
Runtime dependencies:
  1. postgres : databases/postgresql95-server
  2. python2.7 : lang/python27
There are no ports dependent upon this port

Configuration Options
     No options to configure

pgsql:9.5 python tar:bzip2 cpe gmake

Master Sites:

Number of commits found: 8

Commit History - (may be incomplete: see SVNWeb link above for full details)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql95-server
15 Feb 2019 11:02:22
Original commit files touched by this commit  9.5.16
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)
12 Dec 2018 01:35:36
Original commit files touched by this commit  9.5.15_2
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via 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/ 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
08 May 2018 19:37:25
Original commit files touched by this commit  9.5.12
sunpoet search for other commits by this committer
Update WWW

Approved by:	portmgr (blanket)
24 Sep 2017 18:58:59
Original commit files touched by this commit  9.5.9
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
17 Aug 2017 16:19:01
Original commit files touched by this commit  9.5.8_1
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
07 Jan 2017 21:42:28
Original commit files touched by this commit  9.5.5_1
sunpoet search for other commits by this committer
Add more PLIST_SUB to Mk/Uses/


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

PR:		205807
Differential Revision:
Exp-run by:	antoine
01 Jul 2016 17:45:51
Original commit files touched by this commit  9.5.3
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.

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)
07 Jan 2016 19:58:47
Original commit files touched by this commit  9.5.0
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:

What's New in 9.5:

Number of commits found: 8

User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
How big is it?
The latest upgrade!

Enter Keywords:

Latest Vulnerabilities
dovecotApr 18
libssh2Apr 18
giteaApr 17
mariadb101-serverApr 13
mariadb102-serverApr 13
mariadb103-serverApr 13
mariadb55-serverApr 13
mysql56-serverApr 13
mysql57-serverApr 13
mysql80-serverApr 13
percona55-serverApr 13
percona56-serverApr 13
percona57-serverApr 13
wgetApr 12
gitlab-ceApr 11

10 vulnerabilities affecting 128 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-04-18 16:21:36

Deleted ports
Sanity Test Failures

NEW Graphs (Javascript)

Calculated hourly:
Port count 36712
Broken 124
Deprecated 653
Ignore 345
Forbidden 3
Restricted 164
Vulnerable 36
Expired 513
Set to expire 628
Interactive 0
new 24 hours 6
new 48 hours9
new 7 days36
new fortnight51
new month125

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2019 Dan Langille. All rights reserved.