From ff90d8c672b9c45b13df9a359383ccfd8d607328 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 30 Mar 2009 20:32:49 +0000 Subject: [PATCH] More release note adjustments, reordering. --- doc/src/sgml/release.sgml | 347 ++++++++++++++++++++------------------ 1 file changed, 182 insertions(+), 165 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 5e7589c7f7..946c78cb84 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -125,10 +125,29 @@ do it for earlier branch release files. This was available previously via a configure - --enable-integer-datetimes. + --enable-integer-datetimes option. + + + Remove ipcclean utility command (Bruce) + + + + The utility only worked on a few platforms; users should use + their operating system tools instead. + + + + + + + + + Server Settings + + Change postgresql.conf default for log_min_messages @@ -204,19 +223,9 @@ do it for earlier branch release files. - Remove ipcclean utility command (Bruce) - - - - The utility only worked on a few platforms; users should use - their operating system tools instead. - - - - - - The pg_hba.conf section below also has extensive - changes related to migration. + The pg_hba.conf + section below also has extensive changes related to migration. @@ -288,7 +297,7 @@ do it for earlier branch release files. - Functions and Operators + General Functions and Operators @@ -323,6 +332,31 @@ do it for earlier branch release files. + + + Remove ~=~ and ~<>~ operators + used for LIKE index comparisons (Tom) bjm: needed, + pg_upgrade impact? + + + + A not-immediately-obvious incompatibility is that the sort + order within bpchar_pattern_ops indexes changes + --- it had been identical to plain strcmp(), but + is now trailing-blank-insensitive. This will impact in-place + upgrades, if those ever happen. + + + + + + + + + Temporal Functions and Operators + + + Have to_char()'s localized month/day names depend @@ -381,22 +415,6 @@ do it for earlier branch release files. - - - Remove ~=~ and ~<>~ operators - used for LIKE index comparisons (Tom) bjm: needed, - pg_upgrade impact? - - - - A not-immediately-obvious incompatibility is that the sort - order within bpchar_pattern_ops indexes changes - --- it had been identical to plain strcmp(), but - is now trailing-blank-insensitive. This will impact in-place - upgrades, if those ever happen. - - - @@ -547,27 +565,29 @@ do it for earlier branch release files. - Wide-Value Storage (<acronym>TOAST</>) + Server Settings - Consider TOAST compression on values as short as - 32 bytes (previously 256 bytes) (Tom) + Convert many postgresql.conf settings to enumerated + values so pg_settings can easily display valid + values (Magnus) - Require 25% of space savings before using TOAST - compression (previously 20%) (Tom) + Add cursor_tuple_fraction parameter to control the + fraction of a cursor's rows expected to be requested by the + user (Robert Hell) - Be more aggressive in storing EXTERNAL and - EXTENDED column values in TOAST(Tom) + Allow underscores in postgresql.conf custom variable + classes (Tom) @@ -576,29 +596,27 @@ do it for earlier branch release files. - Server Settings + Authentication - Convert many postgresql.conf settings to enumerated - values so pg_settings can easily display valid - values (Magnus) + Report appropriate error message for combination of MD5 + authentication and db_user_namespace enabled (Bruce) - Add cursor_tuple_fraction parameter to control the - fraction of a cursor's rows expected to be requested by the - user (Robert Hell) + Support regular expressions in pg_ident.conf + (Magnus) - Allow underscores in postgresql.conf custom variable - classes (Tom) + Allow Kerberos/GSSAPI parameters + to be changed without restarting the postmaster (Magnus) @@ -606,88 +624,109 @@ do it for earlier branch release files. - - Monitoring + + <filename>pg_hba.conf</> - Add pg_conf_load_time() to report when - the Postgres configuration files were last loaded (George - Gensure) + Parse pg_hba.conf in the postmaster so errors are + reported on reload (Magnus) + + + + Previously errors in the file wouldn't be detected until clients + tried to connect, which could leave the system with a broken + file loaded. - Add pg_terminate_backend() to safely terminate a - backend (the SIGTERM signal works also) (Tom, Bruce) + Remove the sameuser option, making it the default + if no usermap is specified (Magnus) - Add ability to track user-defined functions call counts and - runtimes via parameter track_functions (Martin - Pihlak) + Change all authentication options to be name=value + settings (Magnus) - + + + - Function statistics appear in a new system table, - pg_stat_user_functions. However, inlined - SQL functions are not tracked. + Allow usermap parameter for all external authentication methods + (Magnus) + + + + Previously this was only supported for ident + authentication. - Allow specification of the maximum pg_stat_activity - query string size via track_activity_query_size - parameter (Thomas Lee) + Allow ident authentication over Unix-domain sockets + on Solaris (Garick Hamlin) - Improve syslog performance by increasing the maximum line length - (Tom) + Add clientcert option to control requesting of a + client certificate (Magnus) - - - Add read-only postgresql.conf variables segment_size, - wal_block_size, and wal_segment_size (Bernd Helmle) + Previously this was controlled by the presence of a root + certificate file in the server's data directory. - When reporting a deadlock, report all session queries involved - in the deadlock to the server log (Itagaki Takahiro) + Add cert authentication method to allow user + authentication via SSL certificates (Magnus) + + + + Previously SSL certificates could only verify that + the client had access to a certificate, not authenticate a + user. - New pg_stat_get_activity(pid) function to return - information about a specific process id (Magnus) + Allow krb5, gssapi and sspi + realm and krb5 host settings to be specified in + pg_hba.conf (Magnus) + + + + These override the settings in postgresql.conf. - Move the server statistics file into the subdirectory - pg_stat_tmp and allow its location to be specified - via stats_temp_directory (Magnus) + Add krb5, gssapi, and sspi + include_realm parameter (Magnus) - This allows the statistics file to be placed in a - RAM-resident directory to reduce I/O requirements. - On startup/shutdown, the file is copied to the top-level - $PGDATA directory so it is preserved between - restarts. + This allows identical usernames from different realms to be + authenticated as different database users using usermaps. + + + + + + Show all parsing errors instead of aborting after the first + one (Selena Deckelmann) @@ -738,137 +777,87 @@ do it for earlier branch release files. - Authentication + Monitoring - Report appropriate error message for combination of MD5 - authentication and db_user_namespace enabled (Bruce) - - - - - - Support regular expressions in pg_ident.conf - (Magnus) + Add pg_conf_load_time() to report when + the Postgres configuration files were last loaded (George + Gensure) - Allow Kerberos/GSSAPI parameters - to be changed without restarting the postmaster (Magnus) + Add pg_terminate_backend() to safely terminate a + backend (the SIGTERM signal works also) (Tom, Bruce) - - - - - - <filename>pg_hba.conf</> - - - Parse pg_hba.conf in the postmaster so errors are - reported on reload (Magnus) - - - - Previously errors in the file wouldn't be detected until clients - tried to connect, which could leave the system with a broken - file loaded. + Add ability to track user-defined functions call counts and + runtimes via parameter track_functions (Martin + Pihlak) - - - Remove the sameuser option, making it the default - if no usermap is specified (Magnus) + Function statistics appear in a new system table, + pg_stat_user_functions. However, inlined + SQL functions are not tracked. - Change all authentication options to be name=value - settings (Magnus) - - - - - - Allow usermap parameter for all external authentication methods - (Magnus) - - - - Previously this was only supported for ident - authentication. + Allow specification of the maximum pg_stat_activity + query string size via track_activity_query_size + parameter (Thomas Lee) - Allow ident authentication over Unix-domain sockets - on Solaris (Garick Hamlin) + Improve syslog performance by increasing the maximum line length + (Tom) - Add clientcert option to control requesting of a - client certificate (Magnus) - - - - Previously this was controlled by the presence of a root - certificate file in the server's data directory. + Add read-only postgresql.conf variables segment_size, + wal_block_size, and wal_segment_size (Bernd Helmle) - Add cert authentication method to allow user - authentication via SSL certificates (Magnus) - - - - Previously SSL certificates could only verify that - the client had access to a certificate, not authenticate a - user. + When reporting a deadlock, report all session queries involved + in the deadlock to the server log (Itagaki Takahiro) - Allow krb5, gssapi and sspi - realm and krb5 host settings to be specified in - pg_hba.conf (Magnus) - - - - These override the settings in postgresql.conf. + New pg_stat_get_activity(pid) function to return + information about a specific process id (Magnus) - Add krb5, gssapi, and sspi - include_realm parameter (Magnus) - - - - This allows identical usernames from different realms to be - authenticated as different database users using usermaps. + Move the server statistics file into the subdirectory + pg_stat_tmp and allow its location to be specified + via stats_temp_directory (Magnus) - - - Show all parsing errors instead of aborting after the first - one (Selena Deckelmann) + This allows the statistics file to be placed in a + RAM-resident directory to reduce I/O requirements. + On startup/shutdown, the file is copied to the top-level + $PGDATA directory so it is preserved between + restarts. @@ -979,8 +968,7 @@ do it for earlier branch release files. - Improve the parser's ability to report the error location of - a query (Tom) + Improve the parser's ability to report error locations (Tom) @@ -1683,6 +1671,35 @@ do it for earlier branch release files. + + Wide-Value Storage (<acronym>TOAST</>) + + + + + Consider TOAST compression on values as short as + 32 bytes (previously 256 bytes) (Tom) + + + + + + Require 25% of space savings before using TOAST + compression (previously 20%) (Tom) + + + + + + Be more aggressive in storing EXTERNAL and + EXTENDED column values in TOAST(Tom) + + + + + + + General Functions -- 2.39.5