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.
No installation instructions: this port has been deleted.
The package name of this deleted port was: postgresql81-client
===> The following configuration options are available for postgresql-client-8.1.23:
NLS=on (default) "Use internationalized messages"
PAM=off (default) "Build with PAM support (server only)"
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"
ICU=off (default) "Use ICU for unicode collation (server)"
HIER=off (default) "Builds with query hierarchy (server)"
INTDATE=off (default) "Builds with 64-bit date/time type (server)"
===> Use 'make config' to modify these settings
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.
Also, fix umask error in periodic script .
PR: ports/124457 
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).
Submitted by: edwin@
Approved by: portmgr (pav)
Update postgresql with latest patch release.
A critical fix repairs an error in ReadBuffer that can cause data loss
due to overwriting recently-added pages. This applies to the 8.1 and
8.0 branches on all platforms.
Note that this update might require a reindex of textual columns under
certain conditions; please see UPDATING.
Other fixes included are:
-- Character string locale comparison bug. This may require a REINDEX
on text column indexes in some locales, such as Hungarian.
-- Prevent accidental changes of locale by plperl
-- Two fixes for Japanese encodings
-- Two fixes for COPY CSV
-- Fixes for functions returning RECORD
-- Fixes to autovacuum, dblink and pgcrypto
Welcome to PostgreSQL 8.1.
The new release includes performance improvements and advanced SQL
features which will support bigger data warehouses, higher-volume
transaction processing, and more complex distributed enterprise
Major new features in this release include:
PostgreSQL now supports database roles, which simplify the
management of large numbers of users with complex
overlapping database rights.
(Only the first 15 lines of the commit message are shown above )