Upgrade PostgreSQL to 8.0.2. Here's the brief release note:
Over the past several weeks, Tom Lane has been working on replacing
our old Cache Management Alorithm (ARC) with a new, patent free one
In order to reduce the number of 8.x deployments out there that are
using the old manager, we have just released 8.0.2, and encourage
adminstrators to upgrade at their earliest convience.
For those already running 8.x on your production servers, please
note that this upgrade does *NOT* require a dump restore, but due to
a bump in the major version number for the client library (libpq),
it *WILL* require all client applications to be recompiled at the
For full release info, see
Apart from the upgrade, three new config options are added:
A patch (experimental) for supporting proper collation
of utf-8 encoded locales, using IBM's ICU package (devel/icu). See
http://people.freebsd.org/~girgen/postgresql-icu/README.html for more
An optional patch written by Evgen Potemkin, which allows
PostgreSQL to make hierarchical queries à la Oracle .
An option is added that allows the use of 64 bit ints to
store dates .
PR: ports/79165 , ports/76999 
Submitted by: Marcos Tischer Vallim , Christian Ullrich 
Approved by: ade, seanc (implicit)