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-15T16:56:10Z Doug Barton dougb@FreeBSD.org 2009-07-15T16:56:10Z urn:sha1:0175383f0a1f8b78ed514778532f0467a8ccc6dc propogated by copy and paste. 1. Primarily the "empty variable" default assignment, which is mostly ${name}_flags="", but fix a few others as well. 2. Where they are not already documented, add the existence of the _flags (or other deleted empties) option to the comments, and in some cases add comments from scratch. 3. Replace things that look like: prefix=%%PREFIX%% command=${prefix}/sbin/foo to just use %%PREFIX%%. In many cases the $prefix variable is only used once, and in some cases it is not used at all. 4. In a few cases remove ${name}_flags from command_args 5. Remove a long-stale comment about putting the port's rc.d script in /etc/rc.d (which is no longer necessary). No PORTREVISION bumps because all of these changes are noops. 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-08T06:57:26Z Palle Girgensohn girgen@FreeBSD.org 2009-07-08T06:57:26Z urn:sha1:48e19315dbd5f66e734f2d982642dd15a21d034d 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-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-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-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 2008-02-18T12:55:02Z Palle Girgensohn girgen@FreeBSD.org 2008-02-18T12:55:02Z urn:sha1:2cc30ceb2ac6ed3c16dee6efb3596c73800c29b1 Set update_process_title = off, as suggested by kris@ and others. 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 2007-01-09T16:29:35Z Palle Girgensohn girgen@FreeBSD.org 2007-01-09T16:29:35Z urn:sha1:6b11e898761ec7ced9bf9b652a24b78697eac863 Release notes: http://www.postgresql.org/docs/7.3/static/release.html#RELEASE-7-3-17 http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-15 http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-10 http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-6 http://www.postgresql.org/docs/8.2/static/release-8-2-1.html The server-side utilities of postgresql (initdb, initlocation, ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now installed by the respective postgresql*-server port (previously they where installed with the client). If you update the client, you should also update the server to make sure you are not left without the server-side tools. Do something like: portupgrade postgresql-client postgresql-server