FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=6-eol 2010-12-04T09:10:24Z 2010-12-04T09:10:24Z cvs2svn cvs2svn@FreeBSD.org 2010-12-04T09:10:24Z urn:sha1:058f99bb6be204f053b06d0ad32951709df6109f 2010-09-20T13:46:47Z Palle Girgensohn girgen@FreeBSD.org 2010-09-20T13:46:47Z urn:sha1:c6dcf7810701cd84940844dc8471aa35a71bd7e9 announces the availability of our most eagerly awaited release. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers. 9.0 includes more major features than any release before it, including: * Hot standby * Streaming replication * In-place upgrades * 64-bit Windows builds * Easy mass permissions management * Anonymous blocks and named parameter calls for stored procedures * New windowing functions and ordered aggregates ... and many more. For details on the over 200 additions and improvements in this version, developed by over a hundred contributors, please see the release notes. "These kinds of feature additions continue to make a strong case for why mission-critical technology tasks can continue to depend on the power, flexibility and robustness of PostgreSQL,” said Afilias CTO Ram Mohan. More information on PostgreSQL 9.0: * Release notes http://www.postgresql.org/docs/9.0/static/release-9-0 * Presskit http://www.postgresql.org/about/press/presskit90 * Guide to 9.0: http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.0 --- PR: 150430, Add dtrace 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