PostgreSQL database (client) Maintained by:pgsql@FreeBSD.org Port Added: 08 Jul 2009 06:45:16 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/
NOTE: FreshPorts displays only required dependencies information. Optional dependencies are not covered. Required To Build:devel/gmake Required Libraries:textproc/libxml2, devel/gettext
To install the port:cd /usr/ports/databases/postgresql84-client/ && make install clean To add the package:pkg_add -r postgresql84-client
Configuration Options
===> The following configuration options are available for postgresql-client-8.4.11:
NLS=on (default) "Use internationalized messages"
DTRACE=off (default) "Build with DTrace probes (server only)"
GSSAPI=off (default) "Build with GSSAPI support"
XML=on (default) "Build with XML data type (server)"
TZDATA=on (default) "Use internal timezone database (server)"
ICU=off (default) "Use ICU for unicode collation (server)"
PAM=off (default) "Build with PAM support (server only)"
LDAP=off (default) "Build with LDAP authentication support"
MIT_KRB5=off (default) "Build with MIT's kerberos support"
HEIMDAL_KRB5=off (default) "Builds with Heimdal kerberos support"
OPTIMIZED_CFLAGS=off (default) "Builds with compiler optimizations (-O3)"
DEBUG=off (default) "Builds with debugging symbols"
INTDATE=on (default) "Builds with 64-bit date/time type (server)"
SSL=on (default) "Build with OpenSSL support"
===> Use 'make config' to modify these settings
Update all PostgreSQL ports to latest versions.
Also, try to break the previous 1:1 relation between FreeBSD system and
PostgreSQL versions installed. Use different PREFIX:es to install
different versions on the same system.
PR: ports/132402, ports/145002, ports/146657
- Update to 8.4.1
- Set INTDATE on as default (this is default by PostgreSQL)
PR: ports/139277
Submitted by: Olli Hauer <ohauer@gmx.de>
Approved by: maintainer timeout (2 months)
Welcome PostgreSQL 8.4
After many years of development, PostgreSQL has become feature-complete in many
areas.
This release shows a targeted approach to adding features (e.g., authentication,
monitoring, space reuse), and adds capabilities defined in the later SQL
standards.
The major areas of enhancement are:
Windowing Functions
Common Table Expressions and Recursive Queries
Default and variadic parameters for functions
Parallel Restore
Column Permissions
Per-database locale settings
Improved hash indexes
Improved join performance for EXISTS and NOT EXISTS queries
Easier-to-use Warm Standby
Automatic sizing of the Free Space Map
Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)
Version-aware psql (backslash commands work against older servers)
Support SSL certificates for user authentication
Per-function runtime statistics
Easy editing of functions in psql
New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin
URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html