FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=main 2005-04-13T23:15:49Z 2005-04-13T23:15:49Z Palle Girgensohn girgen@FreeBSD.org 2005-04-13T23:15:49Z urn:sha1:763de9d278b9b9f456337dfb5abee68f4358669a 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) 2005-02-19T12:07:46Z Palle Girgensohn girgen@FreeBSD.org 2005-02-19T12:07:46Z urn:sha1:9c89540227221ee9001868542fa9f8e5bdceae53 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)