- postgresql94-server The most advanced open-source database available anywhere
9.4.1 databases =4
- Maintainer: pgsql@FreeBSD.org
Port Added: 18 May 2014 14:45:02
License: not specified in port
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 : Distfiles Availability : PortsMon
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.Build dependencies:
- libcrypto.so.8 : security/openssl
- gmake : devel/gmake
- msgfmt : devel/gettext-tools
- libcrypto.so.8 : security/openssl
- libxml2.so : textproc/libxml2
- libpq.so.5 : databases/postgresql94-client
- 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...
To install the port:
cd /usr/ports/databases/postgresql94-server/ && make install clean
To add the package:
pkg install databases/postgresql94-server
===> The following configuration options are available for postgresql94-server-9.4.1:
DEBUG=off: Builds with debugging symbols
DTRACE=off: Build with DTrace probes (server only)
GSSAPI=off: Build with GSSAPI support
ICU=off: Use ICU for unicode collation (server)
INTDATE=on: Builds with 64-bit date/time type (server)
LDAP=off: Build with LDAP authentication support (server only)
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
TZDATA=on: Use internal timezone database (server)
XML=on: Build with XML data type (server)
====> 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
tar:bzip2 gmake pgsql:9.4 gettext
Number of commits found: 11
|Commit History - (may be incomplete: see SVNWeb link above for full details)
|07 Feb 2015 17:18:49
In previous commit,
"Revert the change from readline to libedit, and instead make libedit
I failed to get the PORTREVISION set correctly. Fixed now.
|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.
|18 Dec 2014 15:42:18
Release PostgreSQL 9.4
Major enhancements in PostgreSQL 9.4 include:
Add jsonb, a more capable and efficient data type for storing JSON data
Add new SQL command ALTER SYSTEM for changing postgresql.conf configuration
Reduce lock strength for some ALTER TABLE commands
Allow materialized views to be refreshed without blocking concurrent reads
Add support for logical decoding of WAL data, to allow database changes to be
streamed out in a customizable format
Allow background worker processes to be dynamically registered, started and
terminated The above items are explained in more detail in the sections below.
|19 Nov 2014 16:09:15
Update PostgreSQL 9.4 to release candidate 1.
|09 Oct 2014 15:20:53
Update to PostgreSQL 9.4 beta3
|25 Aug 2014 16:44:08
Remove some duplicate lines from plist (or duplicate plist)
Reported by: pkg developer mode
|02 Aug 2014 07:01:54
- Unbreak builds after the lang/python27 update (r363790)
Exp-run: 192242, 192244
|09 Jun 2014 21:57:43
Prepare for upcoming ICU-5.3 upgrade.
|31 May 2014 16:37:58
- Fix various distinfo errors
- Remove unused USE_* knobs
- Convert USE_TWISTED_RUN to USES
- Remove empty lines after .include <bsd.port.mk>
Approved by: portmgr (antoine)
|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
11 vulnerabilities affecting 36 ports have been reported in the past 14 days
* - modified, not new