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

Update PostgreSQL to latest versions. For details on the fixes,

2005-05-10T23:42:54Z

please see the HISTORY file included in the Release, but a summary consists of: * Change encoding function signature to prevent misuse * Change "contrib/tsearch2" to avoid unsafe use of INTERNAL function results * Repair race condition between relation extension and VACUUM This could theoretically have caused loss of a page's worth of freshly-inserted data, although the scenario seems of very low probability. There are no known cases of it having caused more than an Assert failure. Security: http://www.postgresql.org/about/news.315

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

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)

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)

Update JDBC support to version 8.0 (build 310).

2005-02-11T00:10:59Z

The PostgreSQL JDBC project has been decoupled from the server distribution, and is now hosted at http://jdbc.postgresql.org/. 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)

local/java/classes is part of mtree, so don't remove when

2005-02-06T22:04:19Z

deinstalling. Approved by: ade (mentor)

In order to address a potential security hole recently identified with

2005-02-03T09:30:27Z

the "LOAD" option, the PostgreSQL Global Development Group is announcing the release of new versions of PostgreSQL. Update to 7.3.9, 7.4.7 & 8.0.1. Take the opportunity to reset PORTREVISION of slave ports. Back out name change of startup script. The new script uses rc.subr(8), and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD 4.x. Hence rename the script it back to the top of the directory list. [1] The periodic script should of course be executable. [2] [1] Noted by Niels Chr. Bank-Pedersen [2] Noted by Fritz Heinrichmeyer

Split the postgresql ports into a server and a client part. The

2005-01-31T00:19:47Z

following knobs can be used by ports depending on PostgreSQL: # USE_PGSQL - Add PostgreSQL client dependency. # If no version is given (by the maintainer via the port or # by the user via defined variable), try to find the # currently installed version. Fall back to default if # necessary (PostgreSQL-7.4 = 74). # DEFAULT_PGSQL_VER # - PostgreSQL default version. Can be overridden within a port. # Default: 74. # WANT_PGSQL_VER # - Maintainer can set an arbitrary version of PostgreSQL by # using it. # BROKEN_WITH_PGSQL # - This variable can be defined if the ports doesn't support # one or more versions of PostgreSQL. Note that a periodic script is installed that will, by default, vacuum all databases nightly. You may want to tweak the settings, see the script at ${LOCALBASE}/etc/periodic/daily/502.pgsql To run PostgreSQL at boot time, set postgresql_enable=yes in /etc/rc.conf. Note PR: 75344 Approved by: portmgr@ (kris), ade & sean (mentors)

PR ports/75344 - This needs testing and an probably experimental

2004-12-21T20:16:16Z

build, so it will not be out the door before the ports freeze. Meanwhile, modify BROKEN text to something more informative. Approved by: ade (mentor)