FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=release%2F8.0.0 2009-11-14T12:33:33Z 2009-11-14T12:33:33Z cvs2svn cvs2svn@FreeBSD.org 2009-11-14T12:33:33Z urn:sha1:cc415305a049ca523f2a8cf674009fa77c54fee6 2009-07-08T20:31:53Z Palle Girgensohn girgen@FreeBSD.org 2009-07-08T20:31:53Z urn:sha1:894d319504f1a6684a135da6698c664b4a9740df Also, inform about pg_standby rather than autovacuum. [1] PR: 136468 [1] 2009-07-07T22:30:06Z Palle Girgensohn girgen@FreeBSD.org 2009-07-07T22:30:06Z urn:sha1:00c3beec3943b166c0dd223e40358d5062439fa7 After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are: Windowing Functions Common Table Expressions and Recursive Queries Default and variadic parameters for functions Parallel Restore Column Permissions Per-database locale settings Improved hash indexes Improved join performance for EXISTS and NOT EXISTS queries Easier-to-use Warm Standby Automatic sizing of the Free Space Map Visibility Map (greatly reduces vacuum overhead for slowly-changing tables) Version-aware psql (backslash commands work against older servers) Support SSL certificates for user authentication Per-function runtime statistics Easy editing of functions in psql New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html 2009-03-18T15:13:39Z Palle Girgensohn girgen@FreeBSD.org 2009-03-18T15:13:39Z urn:sha1:e6109cdbcf9ebe450a8567e9bc392d8ed8b60748 The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.3.7, 8.2.13, 8.1.17, 8.0.21 and 7.4.25. This release fixes a denial of service issue with encoding conversion, and all users should update their installations at the next reasonable opportunity. There are 12 other minor fixes contained in these update releases, including fixes for xpath() functions in version 8.3. See the release notes for full details. URL: http://www.postgresql.org/docs/8.3/static/release-8-3-7.html URL: http://www.postgresql.org/docs/8.2/static/release-8-2-13.html URL: http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-17 URL: http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-21 URL: http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-24 2009-02-10T11:59:15Z Palle Girgensohn girgen@FreeBSD.org 2009-02-10T11:59:15Z urn:sha1:4faeb886a5b489d9c68a0dd15ae8faf2e3e72545 URL: http://www.postgresql.org/about/news.1055 The PostgreSQL Project today released updates to all active branches of the PostgreSQL object-relational database system, including versions 8.3.6, 8.2.12, 8.1.16, 8.0.20 and 7.4.24. These updates include two serious fixes, for autovacuum crashes in version 8.1 and GiST indexing data loss in 8.3, and those two versions should be updated as soon as possible. These update releases also include patches for several low-risk security holes, as well as up to 17 other minor fixes, depending on your major version of PostgreSQL. Included as well are Daylight Savings Time changes for Nepal, Switzerland and Cuba. See the release notes for full details. The first serious issue affects users who are using version 8.1 with Autovacuum, which will fail when XID rollover is required. The second serious issue can cause data loss when CLUSTER is used with GiST indexes (such as full text indexes) on version 8.3. Both issues are fixed in these releases. 2008-11-07T18:07:50Z Palle Girgensohn girgen@FreeBSD.org 2008-11-07T18:07:50Z urn:sha1:1c63d5a340ebb83fbf2719eb96101c82cbc22c0e 2008-11-07T09:49:49Z Palle Girgensohn girgen@FreeBSD.org 2008-11-07T09:49:49Z urn:sha1:978e3de48fd8491061803765cdc592ab234edd46 http://www.postgresql.org/docs/current/static/release-8-3-5.html http://www.postgresql.org/docs/current/static/release-8-2-11.html http://www.postgresql.org/docs/current/static/release-8-1-15.html http://www.postgresql.org/docs/current/static/release-8-0-19.html http://www.postgresql.org/docs/current/static/release-7-4-23.html Note that the GiST problem mentioned does not apply to users of the FreeBSD port, since the previous version of PostgreSQL never reached the ports tree, due to the freeze of the tree pending the FreeBSD 7.1 update. PR: 121848, 124713 2008-09-01T11:59:12Z Palle Girgensohn girgen@FreeBSD.org 2008-09-01T11:59:12Z urn:sha1:2181e5d2d4007746c29b6634da8403c1cb986238 2008-08-20T00:57:32Z Ade Lovett ade@FreeBSD.org 2008-08-20T00:57:32Z urn:sha1:771ea13f4111cf3212b9c32c18ac5fc1975d483d Tested by: exp build run (erwin) 2008-06-12T23:46:07Z Palle Girgensohn girgen@FreeBSD.org 2008-06-12T23:46:07Z urn:sha1:89025407ac8aa413884e5a33322957c188ca0a40 Updates for all maintained versions of PostgreSQL are available today: 8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than two dozen minor issues reported and patched over the last few months. All PostgreSQL users should plan to update at their earliest convenience. People in affected time zones, in particular, should upgrade as soon as possible. Release Notes: http://www.postgresql.org/docs/8.3/static/release.html Also, fix umask error in periodic script [1]. PR: ports/124457 [1] Submitted by: Alexandre Perrin