PostgreSQL database (client) Maintained by: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.
* - 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-client/ && make install clean To add the package:pkg install databases/postgresql94-client
===> The following configuration options are available for postgresql9-client-9.4.b1_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)
KRB5=off: Build with kerberos provider support
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 have to select exactly 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
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