ports/databases/postgresql90-server, branch release/6.0.0

This commit was manufactured by cvs2svn to create tag 'RELEASE_6_0_0'.

2005-10-16T07:41:55Z

Fixing problems with the recent security patch: When bison was not

2005-05-11T00:40:15Z

installed, the patched gram.y file would not be used and the security patch would be a no-op. Also, I've had reports of compilation errors related to bison. Since checking for the correct version of bison is hard and error prone, I'm doing what the postgresql distribution does - patching the yacc:ed .c file to get rid of the building dependency. Bumping portrevision of -server. Pointy hat to: me Noticed by: Mike Harding and others Security: http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html Approved by: seanc (implicit)

Update the ICU patch with some bug fixes

2005-05-06T02:36:50Z

Update the link to the ICU patch.

2005-04-16T22:51:52Z

Upgrade PostgreSQL to 8.0.2. Here's the brief release note:

2005-04-13T23:15:49Z

Over the past several weeks, Tom Lane has been working on replacing our old Cache Management Alorithm (ARC) with a new, patent free one (2Q). 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 same time. For full release info, see http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-2 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 info. An optional patch written by Evgen Potemkin, which allows PostgreSQL to make hierarchical queries à la Oracle [1]. An option is added that allows the use of 64 bit ints to store dates [2]. PR: ports/79165 [1], ports/76999 [2] Submitted by: Marcos Tischer Vallim [1], Christian Ullrich [2] Approved by: ade, seanc (implicit)

Modify 8.0's startup script to simulate a full login (su -l) [1]. Also

2005-03-19T03:51:45Z

add support to select login class for running postgresql [2]. The new startup script, using rc.subr, is now installed for all versions of postgresql. Bump portrevisions, since startup script is modified. PR: 78630 [1] Submitted by: Vivek Khera [1] Submitted by: Brian B. [2] Approved by: seanc (implicit)

Fixing problems with the recent security patch: When bison was not

2005-02-20T05:38:24Z

Fix security alert using a patch from PostgreSQL's CVS repository:

2005-02-19T12:07:46Z

Prevent overrunning a heap-allocated buffer if more than 1024 parameters to a refcursor declaration are specified. This is a minimally-invasive fix for the buffer overrun. Define LATEST_LINK to avoid package name clashes between the different branches of PostgreSQL. [1] (Since postgresql-tcltk is hardwired to branch 7.4, keep its LATEST_LINK to a generic value.) Set UNIQUENAME and let it be the same for server & client, so each branch's ports will share the same options file. This adds some no-op knobs to the -client port, but IMO it is better this way. Add space inside paranthesis in OSVERSION conditional to work around (ancient) make bug. [2] Remove the Rendez-Vouz knob for 8.0 since I can't find the software needed to even compile it on FreeBSD. Bump portrevision (for -server only). Noted by: kris [1] PR: ports/77530 [2] Security: http://www.vuxml.org/freebsd/6b4b0b3f-8127-11d9-a9e7-0001020eed82.html Approved by: seanc (mentor)

The postgresql_* knobs from /etc/rc.conf where read too late to

2005-02-15T00:30:50Z

actually make a difference. Noticed by: Salvatore Montefusco, Brian B. Approved by: ade (mentor)

Let pkg-message reflect the renaming of the startup script.

2005-02-09T17:48:10Z

Submitted by: Nick Pavlica Approved by: ade (mentor)