| Server IP : 103.119.228.120 / Your IP : 3.129.195.254 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-9.2.24/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Release 9.2.1</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Release Notes"
HREF="release.html"><LINK
REL="PREVIOUS"
TITLE="Release 9.2.2"
HREF="release-9-2-2.html"><LINK
REL="NEXT"
TITLE="Release 9.2"
HREF="release-9-2.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Release 9.2.2"
HREF="release-9-2-2.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Appendix E. Release Notes</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Release 9.2"
HREF="release-9-2.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RELEASE-9-2-1"
>E.24. Release 9.2.1</A
></H1
><DIV
CLASS="FORMALPARA"
><P
><B
>Release date: </B
>2012-09-24</P
></DIV
><P
> This release contains a variety of fixes from 9.2.0.
For information about new features in the 9.2 major release, see
<A
HREF="release-9-2.html"
>Section E.25</A
>.
</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN114293"
>E.24.1. Migration to Version 9.2.1</A
></H2
><P
> A dump/restore is not required for those running 9.2.X.
</P
><P
> However, you may need to perform <TT
CLASS="COMMAND"
>REINDEX</TT
> and/or
<TT
CLASS="COMMAND"
>VACUUM</TT
> operations to recover from the effects of the data
corruption bug described in the first changelog item below.
</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN114299"
>E.24.2. Changes</A
></H2
><P
></P
><UL
><LI
><P
> Fix persistence marking of shared buffers during WAL replay
(Jeff Davis)
</P
><P
> This mistake can result in buffers not being written out during
checkpoints, resulting in data corruption if the server later crashes
without ever having written those buffers. Corruption can occur on
any server following crash recovery, but it is significantly more
likely to occur on standby slave servers since those perform much
more WAL replay. There is a low probability of corruption of btree
and GIN indexes. There is a much higher probability of corruption
of table <SPAN
CLASS="QUOTE"
>"visibility maps"</SPAN
>, which might lead to wrong answers
from index-only scans. Table data proper cannot be corrupted by this
bug.
</P
><P
> While no index corruption due to this bug is known to have occurred
in the field, as a precautionary measure it is recommended that
production installations <TT
CLASS="COMMAND"
>REINDEX</TT
> all btree and GIN
indexes at a convenient time after upgrading to 9.2.1.
</P
><P
> Also, it is recommended to perform a <TT
CLASS="COMMAND"
>VACUUM</TT
> of all tables
while having <A
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-TABLE-AGE"
><TT
CLASS="VARNAME"
>vacuum_freeze_table_age</TT
></A
>
set to zero. This will fix any incorrect visibility map data. <A
HREF="runtime-config-resource.html#GUC-VACUUM-COST-DELAY"
><TT
CLASS="VARNAME"
>vacuum_cost_delay</TT
></A
>
can be adjusted to reduce the performance impact of vacuuming, while
causing it to take longer to finish.
</P
></LI
><LI
><P
> Fix possible incorrect sorting of output from queries involving
<TT
CLASS="LITERAL"
>WHERE <TT
CLASS="REPLACEABLE"
><I
>indexed_column</I
></TT
> IN
(<TT
CLASS="REPLACEABLE"
><I
>list_of_values</I
></TT
>)</TT
> (Tom Lane)
</P
></LI
><LI
><P
> Fix planner failure for queries involving <TT
CLASS="LITERAL"
>GROUP BY</TT
>
expressions along with window functions and aggregates (Tom Lane)
</P
></LI
><LI
><P
> Fix planner's assignment of executor parameters (Tom Lane)
</P
><P
> This error could result in wrong answers from queries that scan the
same <TT
CLASS="LITERAL"
>WITH</TT
> subquery multiple times.
</P
></LI
><LI
><P
> Improve planner's handling of join conditions in index scans (Tom Lane)
</P
></LI
><LI
><P
> Improve selectivity estimation for text search queries involving
prefixes, i.e. <TT
CLASS="REPLACEABLE"
><I
>word</I
></TT
><TT
CLASS="LITERAL"
>:*</TT
> patterns (Tom Lane)
</P
></LI
><LI
><P
> Fix delayed recognition of permissions changes (Tom Lane)
</P
><P
> A command that needed no locks other than ones its transaction already
had might fail to notice a concurrent <TT
CLASS="COMMAND"
>GRANT</TT
> or
<TT
CLASS="COMMAND"
>REVOKE</TT
> that committed since the start of its transaction.
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>ANALYZE</TT
> to not fail when a column is a domain over an
array type (Tom Lane)
</P
></LI
><LI
><P
> Prevent PL/Perl from crashing if a recursive PL/Perl function is
redefined while being executed (Tom Lane)
</P
></LI
><LI
><P
> Work around possible misoptimization in PL/Perl (Tom Lane)
</P
><P
> Some Linux distributions contain an incorrect version of
<TT
CLASS="FILENAME"
>pthread.h</TT
> that results in incorrect compiled code in
PL/Perl, leading to crashes if a PL/Perl function calls another one
that throws an error.
</P
></LI
><LI
><P
> Remove unnecessary dependency on <SPAN
CLASS="APPLICATION"
>pg_config</SPAN
> from
<SPAN
CLASS="APPLICATION"
>pg_upgrade</SPAN
> (Peter Eisentraut)
</P
></LI
><LI
><P
> Update time zone data files to <SPAN
CLASS="APPLICATION"
>tzdata</SPAN
> release 2012f
for DST law changes in Fiji
</P
></LI
></UL
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="release-9-2-2.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="release-9-2.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Release 9.2.2</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Release 9.2</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>