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-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 2008-01-07T13:51:57Z Palle Girgensohn girgen@FreeBSD.org 2008-01-07T13:51:57Z urn:sha1:1d25499d3df3bf1af37d63c037d37cfa4f33e952 This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772, CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769. Security: http://www.postgresql.org/about/news.905