notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
postgresql95-plperl Write SQL functions for PostgreSQL using Perl5
9.5.18 databases 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
9.5.16Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-01-07 19:59:11
Last Update: 2019-06-29 18:35:23
SVN Revision: 505361
Also Listed In: perl5
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.

WWW: https://www.postgresql.org/
SVNWeb : Homepage
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (13 items)
  1. /usr/local/share/licenses/postgresql95-plperl-9.5.18/catalog.mk
  2. /usr/local/share/licenses/postgresql95-plperl-9.5.18/LICENSE
  3. /usr/local/share/licenses/postgresql95-plperl-9.5.18/PostgreSQL
  4. include/postgresql/server/plperl.h
  5. include/postgresql/server/ppport.h
  6. share/postgresql/extension/plperlu--1.0.sql
  7. share/postgresql/extension/plperl.control
  8. share/postgresql/extension/plperl--1.0.sql
  9. share/postgresql/extension/plperlu.control
  10. share/postgresql/extension/plperlu--unpackaged--1.0.sql
  11. share/postgresql/extension/plperl--unpackaged--1.0.sql
  12. share/doc/postgresql/README-plperl
  13. lib/postgresql/plperl.so
  14. Collapse this list.
Dependency lines:
  • postgresql95-plperl>0:databases/postgresql95-plperl
Conflicts:
  • CONFLICTS:
    • 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-plperl/ && make install clean
To add the package: pkg install postgresql95-plperl

PKGNAME: postgresql95-plperl

There is no flavor information for this port.

distinfo:

TIMESTAMP = 1561409472
SHA256 (postgresql/postgresql-9.5.18.tar.bz2) = dfc940487ed5acd5f657d6d02d53a18f9699888d4b0f820071e4564ed2f9f3dd
SIZE (postgresql/postgresql-9.5.18.tar.bz2) = 17570161
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. gmake : devel/gmake
  2. perl5>=5.28.r1<5.29 : lang/perl5.28
Runtime dependencies:
  1. postgres : databases/postgresql95-server
  2. perl5>=5.28.r1<5.29 : lang/perl5.28
Library dependencies:
  1. libreadline.so.8 : devel/readline
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
perl5 readline tar:bzip2 cpe gmake

Master Sites:
  1. https://ftp.postgresql.org/pub/source/v9.5.18/

Number of commits found: 11

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
DateByDescription
29 Jun 2019 17:35:23
Original commit files touched by this commit  9.5.18
Revision:505361
mat search for other commits by this committer
Make sure we don't clobber slave ports' PORTREVISION.
27 Jun 2019 21:28:00
Original commit files touched by this commit  9.5.18
Revision:505245
girgen search for other commits by this committer
Upgrade PostgreSQL to latest version

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 11.4, 10.9, 9.6.14, 9.5.18, and
9.4.23, as well as the second beta of PostgreSQL 12. This release fixes one
security issue and over 25 bugs since the previous cumulative update in May.

This release is made outside of the normal update release schedule as the
security vulnerability was determined to be critical enough to distribute the
fix as quickly as possible. Users who are running PostgreSQL 10, PostgreSQL 11,
or the PostgreSQL 12 beta should upgrade as soon as possible.

All other users should plan to apply this update at the next scheduled
downtime.

Release notes:	https://www.postgresql.org/about/news/1949/
Security:	245629d4-991e-11e9-82aa-6cc21735f730
09 Apr 2019 14:04:50
Original commit files touched by this commit  9.5.16
Revision:498476
sunpoet search for other commits by this committer
Update devel/readline to 8.0

- Bump PORTREVISION of dependent ports for shlib change

Changes:	https://tiswww.case.edu/php/chet/readline/CHANGES
PR:		236156
Exp-run by:	antoine
15 Feb 2019 11:02:22
Original commit files touched by this commit  9.5.16
Revision:492989
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
Revision:487272
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
24 Sep 2017 18:58:59
Original commit files touched by this commit  9.5.9
Revision:450532
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
05 Sep 2017 09:27:11
Original commit files touched by this commit  9.5.9
Revision:449278
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 9.6.5, 9.5.9,
9.4.14, 9.3.19, and 9.2.23.

This release includes fixes that prevent a crash in pg_restore when
using parallel mode. It also patches over a few other bugs reported
since the last releases in August.

Additionally, in 9.4.14 only, there is a fix to an issue with walsenders
preventing primary-server shutdown unless immediate shutdown mode is used.

Users should plan to update at the next convenient downtime.

Bug Fixes and Improvements
(Only the first 15 lines of the commit message are shown above View all of this commit message)
17 Aug 2017 16:19:01
Original commit files touched by this commit  9.5.8_1
Revision:448138
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
27 Jun 2017 13:46:53
Original commit files touched by this commit  9.5.7_1
Revision:444463
sunpoet search for other commits by this committer
Update devel/readline to 7.0 patch 3

- Bump PORTREVISION for shlib change

Changes:	https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES
		https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html
		https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html
Differential Revision:	https://reviews.freebsd.org/D11172
PR:		219947
Exp-run by:	antoine
01 Jul 2016 17:45:51
Original commit files touched by this commit  9.5.3
Revision:417899
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)
07 Jan 2016 19:58:47
Original commit files touched by this commit  9.5.0
Revision:405482
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: 11

Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
jenkinsJul 17
jenkins-ltsJul 17
libxsltJul 16
asterisk13Jul 12
asterisk13Jul 12
asterisk15Jul 12
asterisk15Jul 12
asterisk16Jul 12
asterisk16Jul 12
python37Jul 12
firefoxJul 09
firefox*Jul 09
firefox-esrJul 09
firefox-esr*Jul 09
gnupgJul 09

14 vulnerabilities affecting 153 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-07-17 15:55:25


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36991
Broken 93
Deprecated 99
Ignore 326
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 30
Expired 14
Set to expire 69
Interactive 0
new 24 hours 4
new 48 hours11
new 7 days29
new fortnight60
new month126

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