- postgresql94-client PostgreSQL database (client)
9.4.12 databases =7
- Maintainer: pgsql@FreeBSD.org
Port Added: 18 May 2014 14:45:02
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: http://www.postgresql.org/SVNWeb : Homepage : PortsMon
To install the port:
cd /usr/ports/databases/postgresql94-client/ && make install clean
To add the package:
pkg install postgresql94-client
TIMESTAMP = 1494282360
SHA256 (postgresql/postgresql-9.4.12.tar.bz2) = fca055481875d1c49e31c28443f56472a1474b3fbe25b7ae64440c6118f82e64
SIZE (postgresql/postgresql-9.4.12.tar.bz2) = 17833119
SHA256 (postgresql/pg-949-icu-2016-10-02.diff.gz) = 34612e685a79874db04bc6b66c700bfc6412042840c532eef0da7832d1f70d43
SIZE (postgresql/pg-949-icu-2016-10-02.diff.gz) = 5289
- Master port: databases/postgresql94-server
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.Build dependencies:
- pkgconf>=1.3.0_1 : devel/pkgconf
- gmake : devel/gmake
- msgfmt : devel/gettext-tools
- perl5>=5.24<5.25 : lang/perl5.24
- perl5>=5.24<5.25 : lang/perl5.24
- libintl.so : devel/gettext-runtime
This port is required by:for Build
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...
===> The following configuration options are available for postgresql94-client-9.4.12:
DEBUG=off: Build with debugging support
GSSAPI=off: Build with GSSAPI support
LIBEDIT=off: Use non-GPL libedit instead of readline
NLS=on: Use internationalized messages
OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
PAM=off: Build with PAM Support
SSL=on: Build with OpenSSL support
====> Build with kerberos provider support: you can only select none or one of them
MIT_KRB5=off: Build with MIT kerberos support
HEIMDAL_KRB5=off: Builds with Heimdal kerberos
===> Use 'make config' to modify these settings
pkgconfig tar:bzip2 cpe gmake perl5 readline gettext ssl
Number of commits found: 11
NOTE: This slave port may no longer be vulnerable to issues shown below because the master port has been updated.
|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/postgresql94-server|
|13 Jan 2016 10:36:22
Some binaries where moved from contrib to base in 9.5, like pgbench and
pg_upgrade. Other where added in 9.5, but the port failed to install them.
Make sure they are properly installed by the correct port (-client or -server)
Remove unused and hence confusing OSSP_UUID parameters from Makefile 
Add options to allow user to be set for the backup script in periodic.
Add this option only to 9.5 for now. It will be updated to other servers at
next regular patch release. 
The path to perl in hard coded into pgxs/src/Makefile.global which is
then installed. Hence, we must depend on perl when that file is installed.
Noticed by: Paul Guyot 
PR: 192387 
PR: 172110 
PR: 206046 
|08 Oct 2015 21:25:01
Update PostgreSQL port to latest version.
Two security issues have been fixed in this release which affect users
of specific PostgreSQL features:
CVE-2015-5289: json or jsonb input values constructed from arbitrary
user input can crash the PostgreSQL server and cause a denial of
CVE-2015-5288: The crypt( function included with the optional pgCrypto
extension could be exploited to read a few additional bytes of memory.
No working exploit for this issue has been developed.
This update will also disable SSL renegotiation by default;
previously, it was enabled by default. SSL renegotiation will be
removed entirely in PostgreSQL versions 9.5 and later.
Security: CVE-2015-5288 CVE-2015-5289
|22 May 2015 23:22:20
Update PostgreSQL ports to latest version.
Data Corruption Fix
For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where
the database will fail to protect against "multixact wraparound", resulting in
data corruption or loss. Users with a high transaction rate (1 million or more
per hour) in a database with many foreign keys are especially vulnerable. We
strongly urge all users of 9.4 and 9.3 to update their installations in the
next few days.
Users of versions 9.2 and earlier are not affected by this issue.
|07 Feb 2015 17:05:08
Revert the change from readline to libedit, and instead make libedit optional.
|05 Feb 2015 22:54:35
Update PostgreSQL-9.x to latests versions.
This update fixes multiple security issues reported in PostgreSQL over the past
few months. All of these issues require prior authentication, and some require
additional conditions, and as such are not considered generally urgent.
However, users should examine the list of security holes patched below in case
they are particularly vulnerable.
|19 Nov 2014 16:09:15
Update PostgreSQL 9.4 to release candidate 1.
|12 Nov 2014 09:53:42
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.
Submitted by: Li-Wen Hsu <lwhsu@FreeBSD.org>
|09 Oct 2014 15:20:53
Update to PostgreSQL 9.4 beta3
|30 Jun 2014 23:07:29
Fixes build with readline from ports
|20 May 2014 21:58:23
fix broken plist
|18 May 2014 14:44:53
The PostgreSQL Global Development Group announced that the first beta
release of PostgreSQL 9.4, the latest version of the world's leading
open source database, is available today. This beta contains previews
of all of the features which will be available in version 9.4, and is
ready for testing by the worldwide PostgreSQL community. Please
download, test, and report what you find.
The new major features available for testing in this beta include:
* JSONB: 9.4 includes the new JSONB "binary JSON" type. This new
storage format for document data is higher-performance, and comes with
indexing, functions and operators for manipulating JSON data.
* Replication: The new Data Change Streaming API allows decoding and
transformation of the replication stream. This lays the foundation
for new replication tools that support high-speed and more flexible
replication and scale-out solutions.
* Materialized Views with "Refresh Concurrently", which permit
fast-response background summary reports for complex data.
* ALTER SYSTEM SET, which enables modifications to postgresql.conf
from the SQL command line and from remote clients, easing
Number of commits found: 11
13 vulnerabilities affecting 47 ports have been reported in the past 14 days
* - modified, not new