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