Split the postgresql ports into a server and a client part. Hence,
remove this port. Please see UPDATING for more info.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)

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

Add myself as committer, and use my @FreeBSD.org address.

Approved by: ade (mentor)

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 version 7.4.5:

* Prevent possible loss of committed transactions during crash
* Repair possible crash during concurrent btree index insertions

PR:             71176
Submitted by:   SUGIMURA Takashi <sugimura@jp.FreeBSD.org>
Reviewed by:    Palle Girgensohn <girgen@pingpong.net> (maintainer)

Upgrade to 7.4.3.

PR:             ports/68456
Submitted by:   maintainer

Add a note about changes in latest release of PostgreSQL.

Submitted by:   Palle Girgensohn <girgen@pingpong.net> (maintainer)
PR:             64933

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

forced commit:  the PR for the previous change was 61835

Add WITHOUT_NLS knob.  Move USE_GETTEXT to proper place.

PR:             61836
Submitted by:   Palle Girgensohn (maintainer)
Pointy hat to:  me

Add USE_GETTEXT and bump PORTREVISION.

Submitted by:   trevor
Tested by:      bento

- Add note that the function "elog" has been removed from
  pg-7.4

PR:             ports/62167
Submitted by:   maintainer

Now gettext 0.12.1 is gettext-old.

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.

Maintainer update to PostgreSQL 7.4.1.  This release includes fixed ident
authentication support for FreeBSD (been broken since 7.4).  Merry
Christmas to all, and to all a good night.

Release notes:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-4-1

Prompted by PR: ports/60542
Obtained from:  maintainer

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>

Make PORTNAME ovverrideable by slave ports again.

This fixes INDEX build

Introduce the world to PostgreSQL 7.4!  By and large this release is
regarded as a major release with features with interest to those with
large databases.  The updates are extensive and the best source of info
is in the release notes.  Enjoy and direct questions to database@!

Release notes:
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4

PR:             ports/59403, ports/59404, ports/59393, ports/59394,
                ports/59395, ports/59397, ports/59398, ports/59402, &&
                ports/59401
Submitted by:   maintainer
Approved by:    marcus (portmgr@ hat)

Set pkg-comment only when there isn't one set yet (make port
master/slave clean)

Bump the PORTREVISION for the ports directly affected by the gettext upgrade.

Prodded by:     kris

Chase the libintl.so shared lib version.

Fix my fault in previous commit: put a pkg-message
 into right place.

Notify from:    Palle Girgensohn <girgen@pingpong.net>

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

get rid of libgnugetopt dependency for -CURRENT,
use USE_GETOPT_LONG instead.

postgresql slave ports, reduce unnecessary portrevision bumps

PR:             52867
Submitted by:   Palle Girgensohn <girgen@pingpong.net> (maintainer)

The control script that ships with the postgres
port (files/pgsql.sh.tmpl) lacks a parameter in the
restart option, causing logs to be send to stdout,
instead of the log file.

Submitted by:   Fernando Schapachnik <fernando@mecon.gov.ar>
Approved by:    maintainer
PR:             53142
Approved by:    fjoe (implicit)

Use ${MASTER_SITE_PGSQL} instead of multiple sites

Submitted by:   osa
Approved by:    maintainer
PR:             50397
Approved by:    fjoe (implicit)

Remove a patch file which is no need for 7.3.3.

Submitted by:   Mike Harding <mvh@ix.netcom.com>

Update to 7.3.3.

1. Optionally link with libc_r to get plpython working. [1]
2. Fix kerberos build. [2]
3. There was a duplication of some declarations. [3]

PR:             ports/52851
PR:             ports/51080 [2]
Submitted by:   Mike Meyer <mwm@mired.org> [1]
Submitted by:   Gerweck <andy@tacnode.com> [2]
Pointed out by: Mike Harding <mvh@ix.netcom.com> [3]
Submitted by:   Palle Girgensohn <girgen@pingpong.net> (maintainer)

Add patch for a fix for braindead applications that were depending on
atoi('') (ex: RT and Horde).  While I'm here, de-"pkg-comment"-ify.  Port
revision bump.

Submitted by:   Larry Rosenman <ler@lerctr.org>
Approved by:    maintainer

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>

Update PostgreSQL to the maintenance release 7.3.2.

Fixes numerous bugs especially with various interface libraries and
pg_dump.  All users are advised to upgrade. This update fixes all known
problems with the postgresql7 port.  See release notes for details:

http://developer.postgresql.org/docs/postgres/release-7-3-2.html

A dump/restore is *not* required when upgrading to this version.

PR:             ports/47983 [1], ports/47284 [2], ports/47808 [3]
Submitted by:   maintainer [1]
                Jason C. Wells [2]
                Michel Oosterhof <m.oosterhof@xs4all.nl> [3]

Add new man pages.

PR:             47054
Submitted by:   Palle Girgensohn <girgen@rambutan.pingpong.net>

Fix DISTFILES typo in databases/postgresql7/Makefile

PR:             ports/46749, ports/46748
Submitted by:   "Sergey A.Osokin" <osa@FreeBSD.org.ru>,Rong-en Fan
<rafan@infor.org>

Download the PostgreSQL documentation and MD5 for the test bundle.  These
should ideally be downloaded as needed to save bandwidth.

Submitted by:   Eric Hodel

Update PostgreSQL to 7.3.1[1].  Fixes builds for spac64.  Many speed,
security, and feature additions.  Reduce diffs between postgresql-devel
port.  Re-initdb required when upgrading from previous release.  See
release notes for details.

Schemas added are system catalogs updated. ::braces for impact::

http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-3-1

PR:             ports/46701
Submitted by:   girgen@pingpong.net

Port update submitted by maintainer

PR: ports/44983
Submitted by: girgen@pingpong.net

Update to 7.2.3 and maintainer's email address. All advised to update
to this version as soon as possible. Check PR description.

PR:             ports/43676
Submitted by:   maintainer

Remove a dead .jp mirror and add the official .jp mirror instead.

Submitted by:   fenner's distfiles survey

Update to 7.2.2, which fixes several security bugs.  Do not install
documentation--it will be in a separate port.

PR:                     42009
Submitted by:           Palle Girgensohn (maintainer)

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

Chase shlib rev of devel/gettext

Submitted by:   lots and lots
Pointy hat to:  ade

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

upgrade to 7.2.1

PR:             36975
Submitted by:   maintainer

Fix some bitrot for the non-default case of WITH_GETTEXT -- lib-depend
on -lintl instead of build-depending on msgfmt and make sure -lintl is
linked into the shared -lpq.

Approved by:    maintainer

Add USE_SUBMAKE, where it might be necessary.

Stage 1 of gettext update.

Move gettext (0.10.35) with gettext-old
Update gettext from gettext-devel (0.10.40)
Remove gettext-devel
Fix dependencies

Stage 2 will involve upgraded gettext to 0.11 and fixing issues
Stage 3 involves a de-orbit burn sequence for gettext-old

Reviewed by:    portmgr

Fix building this Port with Kerberos.   The MAINTAINER has approved this (see
ports/35161).    

Fix a typo: $1 -> $? (we want to check the return code from dialog)    

Upgrade to 7.2, and spilit into several ports.    

pre-everything needs two colons    

Style police: WWW tags should either end in a file/script or TRAILING /; Fix the
later case    

retire problematic MASTER_SITES.    

Correct the config file name.    

Update the PostgreSQL port to 7.1.3.    

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.    

Fix mtree errors preventing automated package building:    

Fix build when BATCH is defined, and remove redundant ${MKDIR} "-p" option.    

The configure script *must* run pre-fetch, since the dependencies are   checked
in the fetch target. Before the patch below, make install will   fail to depend
on Tcl/Tk, for instance.    

Forgotten file.    

Add character sets to the server    

Use proper POSIX syntax for `chown'.    

forget to remove patch    

add Japanese mirror to MASTER_SITES.    

upgrade to 7.1.2    

Change the way the configure script is executed and included in order   to make
dependencies work.   Call the script pre-fetch and include Makefile.inc AFTER it
has been   created.    

Fix the autogenerated LIB_DEPENDS for TCL.    

Upgrade to 7.1.1    

Cosmetic changes for the shutdown procedure.    

Specify the full path of the jakarta port's "ant" utility (/usr/local/bin) so  
it won't be confused with the "ant" screensaver (in /usr/X11R6/bin).    

Misc. changes and cleanups.    

Remove extra empty line.    

Add one more MASTER_SITE    

Fix postgresql.jar link probram, and bump version too.    

Upgrade to 7.1, change to new layout style.    

ldconfig PostgreSQL's lib should happen before starting *ANY* ports.    

Fix problems when installing postgresql7 with pkg_add:   - pkg-install used
wrong uid#   - chown lib dir *after* it is created   - pkg-install created data
dir where Makefile didn't   - add pkg-deinstall and remove user & group   -
don't chown data dir, since we don't create it anymore   - spell and
documentation fixes in the rc.d script    

Remove IS_INTERACTIVE, support batch compilation.    

Treat pgsql's .profile as data: it could have been customized to change the  
default database location.    

Make the port more "package friendly".    

Define IS_INTERACTIVE.    

Do not set the shell for user "pgsql" to `/bin/nologin' at package install  
time: this breaks the rc.d script.  Default to `/bin/sh' as a `make install'  
would do.    

Goodbye, YEAR2000.  Hello, 2001.    

Update to version 7.0.3.    

Palle Girgensohn <girgen@partitur.se> stepped forward and said that he   would
like to maintain this port.    

hand maintenance of this port over to ports@FreeBSD.ORG   due to lack of time
for maintaining and testing. Maybe   somebody other can do better than I.    

Convert category databases to new layout.  

Rename PLIST.* to pkg-plist.*.    

pl/Perl and ODBC support    

avoid:   ldconfig: /usr/local/pgsql/lib: ignoring directory not owned by root  
during startup.    

sorry, forgot to remove that ...    

allow PostgreSQL to compile and run on Alpha.   The DB is 64-bit capable so
really only a few   bits of configuration for FreeBSD were needed.    

-LDCONFIG_DIRS= %%PREFIX%%/pgsql   +LDCONFIG_DIRS= %%PREFIX%%/pgsql/lib    

Use ${PKG_PREFIX} instead of `/usr/local'.    

Update to 7.0.2.    

Enable multibyte support by default, and add knobs to disable it or set the  
default encoding.    

make startup script work (start/stop)    

upgrade postgresql to v 7.0 release   thanks for complete diffs ;-)   closed PR