PostgreSQL database (client) Maintained by:girgen@FreeBSD.org Port Added: 06 Dec 2006 16:49:57
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/
To install the port:cd /usr/ports/databases/postgresql82-client/ && make install clean To add the package:pkg_add -r postgresql82-client
Configuration Options
===> The following configuration options are available for postgresql-client-8.2.13:
NLS=on (default) "Use internationalized messages"
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)"
TESTS=off (default) "Allows the use of a "check" target (server)"
DEBUG=off (default) "Builds with debugging symbols"
INTDATE=off (default) "Builds with 64-bit date/time type (server)"
===> Use 'make config' to modify these settings
Reason:
The server-side utilities of postgresql (initdb, initlocation,
ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now
installed by the respective postgresql*-server port (previously
they where installed with the client). If you update the client, you
should also update the server to make sure you are not left without
the server-side tools. Do something like:
portupgrade postgresql-client postgresql-server
Number of commits found: 8
Commit History - (may be incomplete: see CVSWeb link above for full details)
Updates of the PostgreSQL ports
Updates for all maintained versions of PostgreSQL are available today:
8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than
two dozen minor issues reported and patched over the last few months.
All PostgreSQL users should plan to update at their earliest
convenience. People in affected time zones, in particular, should
upgrade as soon as possible.
Release Notes:
http://www.postgresql.org/docs/8.3/static/release.html
Also, fix umask error in periodic script [1].
PR: ports/124457 [1]
Submitted by: Alexandre Perrin
Bump portrevision due to upgrade of devel/gettext.
The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).
PR: ports/124340
Submitted by: edwin@
Approved by: portmgr (pav)
Update to 8.2.7
Release notes:
http://developer.postgresql.org/pgdocs/postgres/release-8-2-7.html
Remove HIER patch option, since it is not available anymore. The site
is down and original author responses that he does not maintain it
anymore.
PR: ports/116423
Remove option to build and link with thread safety, and always build
thread safe instead. Decided after a discussion with postgresql
hackers, and tested for a while in postgresql83. This helps when
for example linking with openldap, or for using certain programming
languages as postgresql functions.
