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/

Clean up handling of locale directories at deinstall-time:
* Don't remove "system directories" (which were created by BSD.*.dist)
* Silently try to remove locale directories which we might have created

Update postgresql 7.3.7 -> 7.3.8 and 7.4.5 -> 7.4.6 due to security
advisories in http://www.postgresql.org/news/234.html
Note that postgresql 7.2.x is NOT being updated here since it is
due for termination real soon now.
Submitted by: maintainer, also referenced in ports/73142 (no patch)

Update to latest release 7.4.2.
Release notes available at http://www.postgresql.org/news/173.html
NOTICE: unlike most minor versions, this version does require
some updates to the pg_* system tables. Full instructions for
how to do this are included in the full HISTORY file.
DO NOT UPGRADE WITHOUT READING THESE INSTRUCTIONS.
SIZEfy.
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR: 64105

Update the PostgreSQL ports to use the KRB5_HOME variable instead of
LOCALBASE to find krb5-config in the MIT case.
Prodded by: Our friendly folks at the ISC who want to use FreeBSD's
PostgreSQL ports instead of an unmanaged build from a tarball.

Remove the PORTNAME from postgreql-client. PORTNAME is set by
MASTERDIR/Makefile[1]. Improve the CONFLICTS messages[2]. Fix the DEPENDS
so that MIT krb5 depends on security/krb5, not heimdal[3]. Add a file that
was missing in the upgrade that has PostgreSQL log to syslog by default[4].
PR: [4] Originally submitted in ports/59402
Submitted by: [1,2,4] maintainer
[3] keoki seu <keoki@camelot.physics.wm.edu>

Update to 7.3.4
"In order to address a potentially serious (although rare)
server startup failure that was recently reported, we have
released PostgreSQL version 7.3.4. This release is critical
for users of PostgreSQL version 7.3.3, and highly recommended
for all other PostgreSQL users."
Submitted by: Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR: 55354

Add a patch fix a long standing bug in PostgreSQL with LISTEN/NOTIFY
queues and shutting down the database. Not bumping port revision, but if
you are having problems related to the above, update as necessary.
Submitted by: Larry Rosenman <ler@lerctr.org>

Forbid because of unconfirmed security bugs:
The following buffer overruns have been identified and
addressed [in 7.2.2]:
* in handling long datetime input
* in repeat()
* in lpad() and rpad() with multibyte
* in SET TIME ZONE and TZ env var

Fix build on -CURRENT:
* The compiler in -CURRENT now complains if you precede -I/usr/include
with -I... . The same applies to -I/usr/lib .
* The distribution's configure file treats the compiler's unexpected
warning message as a failure and errors out.
Maintainer notified in private mail.

gettext upgrade uber-patch (stage 3)
- switch devel/gettext (0.11.1) on, installing full package
- flip devel/gettext-old (0.10.35) to installing only static binaries
with a "-old" suffix -- gettext-old will have its deorbit burn
sequence initiated just after 4.6-RELEASE
- fix up ports for the new world order
Reviewed by: portmgr

Work around the way in which the package building cluster validates ports by
defining LIB_DEPENDS for the BATCH defaults in the Makefile. The dynamic
determination of LIB_DEPENDS in configure.postgresql remains in place for the
!BATCH case and is unaffected by this.