<!-- doc/src/sgml/release-9.2.sgml -->

<!-- See header comment in release.sgml about typical markup -->

<sect1 id="release-9-2-22">

<title>Release 9.2.22</title>

<formalpara>

<title>Release date:</title>

<para>2017-08-10</para>

</formalpara>

<para>

This release contains a variety of fixes from 9.2.21.

For information about new features in the 9.2 major release, see

<xref linkend="release-9-2">.

</para>

<para>

The <productname>PostgreSQL</> community will stop releasing updates

for the 9.2.X release series in September 2017.

Users are encouraged to update to a newer release branch soon.

</para>

<sect2>

<title>Migration to Version 9.2.22</title>

<para>

A dump/restore is not required for those running 9.2.X.

</para>

<para>

However, if you are upgrading from a version earlier than 9.2.20,

see <xref linkend="release-9-2-20">.

</para>

</sect2>

<sect2>

<title>Changes</title>

<itemizedlist>

<listitem>

<para>

On Windows, retry process creation if we fail to reserve the address

range for our shared memory in the new process (Tom Lane, Amit

Kapila)

</para>

<para>

This is expected to fix infrequent child-process-launch failures that

are probably due to interference from antivirus products.

</para>

</listitem>

<listitem>

<para>

Fix low-probability corruption of shared predicate-lock hash table

in Windows builds (Thomas Munro, Tom Lane)

</para>

</listitem>

<listitem>

<para>

Avoid logging clean closure of an SSL connection as though

it were a connection reset (Michael Paquier)

</para>

</listitem>

<listitem>

<para>

Prevent sending SSL session tickets to clients (Tom Lane)

</para>

<para>

This fix prevents reconnection failures with ticket-aware client-side

SSL code.

</para>

</listitem>

<listitem>

<para>

Fix code for setting <xref linkend="guc-tcp-keepalives-idle"> on

Solaris (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix statistics collector to honor inquiry messages issued just after

a postmaster shutdown and immediate restart (Tom Lane)

</para>

<para>

Statistics inquiries issued within half a second of the previous

postmaster shutdown were effectively ignored.

</para>

</listitem>

<listitem>

<para>

Ensure that the statistics collector's receive buffer size is at

least 100KB (Tom Lane)

</para>

<para>

This reduces the risk of dropped statistics data on older platforms

whose default receive buffer size is less than that.

</para>

</listitem>

<listitem>

<para>

Fix possible creation of an invalid WAL segment when a standby is

promoted just after it processes an <literal>XLOG_SWITCH</> WAL

record (Andres Freund)

</para>

</listitem>

<listitem>

<para>

Fix <systemitem>SIGHUP</> and <systemitem>SIGUSR1</> handling in

walsender processes (Petr Jelinek, Andres Freund)

</para>

</listitem>

<listitem>

<para>

Fix unnecessarily slow restarts of <application>walreceiver</>

processes due to race condition in postmaster (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix cases where an <command>INSERT</> or <command>UPDATE</> assigns

to more than one element of a column that is of domain-over-array

type (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Move autogenerated array types out of the way during

<command>ALTER ... RENAME</> (Vik Fearing)

</para>

<para>

Previously, we would rename a conflicting autogenerated array type

out of the way during <command>CREATE</>; this fix extends that

behavior to renaming operations.

</para>

</listitem>

<listitem>

<para>

Ensure that <command>ALTER USER ... SET</> accepts all the syntax

variants that <command>ALTER ROLE ... SET</> does (Peter Eisentraut)

</para>

</listitem>

<listitem>

<para>

Properly update dependency info when changing a datatype I/O

function's argument or return type from <type>opaque</> to the

correct type (Heikki Linnakangas)

</para>

<para>

<command>CREATE TYPE</> updates I/O functions declared in this

long-obsolete style, but it forgot to record a dependency on the

type, allowing a subsequent <command>DROP TYPE</> to leave broken

function definitions behind.

</para>

</listitem>

<listitem>

<para>

Reduce memory usage when <command>ANALYZE</> processes

a <type>tsvector</> column (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

Fix unnecessary precision loss and sloppy rounding when multiplying

or dividing <type>money</> values by integers or floats (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Tighten checks for whitespace in functions that parse identifiers,

such as <function>regprocedurein()</> (Tom Lane)

</para>

<para>

Depending on the prevailing locale, these functions could

misinterpret fragments of multibyte characters as whitespace.

</para>

</listitem>

<listitem>

<para>

Use relevant <literal>#define</> symbols from Perl while

compiling <application>PL/Perl</> (Ashutosh Sharma, Tom Lane)

</para>

<para>

This avoids portability problems, typically manifesting as

a <quote>handshake</> mismatch during library load, when working with

recent Perl versions.

</para>

</listitem>

<listitem>

<para>

In <application>psql</>, fix failure when <command>COPY FROM STDIN</>

is ended with a keyboard EOF signal and then another <command>COPY

FROM STDIN</> is attempted (Thomas Munro)

</para>

<para>

This misbehavior was observed on BSD-derived platforms (including

macOS), but not on most others.

</para>

</listitem>

<listitem>

<para>

Fix <application>pg_dump</> to not emit invalid SQL for an empty

operator class (Daniel Gustafsson)

</para>

</listitem>

<listitem>

<para>

Fix <application>pg_dump</> output to stdout on Windows (Kuntal Ghosh)

</para>

<para>

A compressed plain-text dump written to stdout would contain corrupt

data due to failure to put the file descriptor into binary mode.

</para>

</listitem>

<listitem>

<para>

Fix <function>pg_get_ruledef()</> to print correct output for

the <literal>ON SELECT</> rule of a view whose columns have been

renamed (Tom Lane)

</para>

<para>

In some corner cases, <application>pg_dump</> relies

on <function>pg_get_ruledef()</> to dump views, so that this error

could result in dump/reload failures.

</para>

</listitem>

<listitem>

<para>

Fix dumping of function expressions in the <literal>FROM</> clause in

cases where the expression does not deparse into something that looks

like a function call (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix <application>pg_basebackup</> output to stdout on Windows

(Haribabu Kommi)

</para>

<para>

A backup written to stdout would contain corrupt data due to failure

to put the file descriptor into binary mode.

</para>

</listitem>

<listitem>

<para>

Fix <application>pg_upgrade</> to ensure that the ending WAL record

does not have <xref linkend="guc-wal-level"> = <literal>minimum</>

(Bruce Momjian)

</para>

<para>

This condition could prevent upgraded standby servers from

reconnecting.

</para>

</listitem>

<listitem>

<para>

Always use <option>-fPIC</>, not <option>-fpic</>, when building

shared libraries with gcc (Tom Lane)

</para>

<para>

This supports larger extension libraries on platforms where it makes

a difference.

</para>

</listitem>

<listitem>

<para>

Fix unescaped-braces issue in our build scripts for Microsoft MSVC,

to avoid a warning or error from recent Perl versions (Andrew

Dunstan)

</para>

</listitem>

<listitem>

<para>

In MSVC builds, handle the case where the <application>openssl</>

library is not within a <filename>VC</> subdirectory (Andrew Dunstan)

</para>

</listitem>

<listitem>

<para>

In MSVC builds, add proper include path for <application>libxml2</>

header files (Andrew Dunstan)

</para>

<para>

This fixes a former need to move things around in standard Windows

installations of <application>libxml2</>.

</para>

</listitem>

<listitem>

<para>

In MSVC builds, recognize a Tcl library that is

named <filename>tcl86.lib</> (Noah Misch)

</para>

</listitem>

</itemizedlist>

</sect2>

</sect1>

<sect1 id="release-9-2-21">

<title>Release 9.2.21</title>