8000 Release notes for 9.6.4, 9.5.8, 9.4.13, 9.3.18, 9.2.22. · codeimmortal/postgres@b35006e · GitHub
[go: up one dir, main page]
Skip to content

Commit b35006e

Browse files
tglsfdctglsfdc
committed
Release notes for 9.6.4, 9.5.8, 9.4.13, 9.3.18, 9.2.22.
1 parent 5af4456 commit b35006e

File tree

5 files changed

+1885
-30
lines changed

5 files changed

+1885
-30
lines changed

‎doc/src/sgml/release-9.2.sgml

Lines changed: 341 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,347 @@
11
<!-- doc/src/sgml/release-9.2.sgml -->
22
<!-- See header comment in release.sgml about typical markup -->
33

4+
<sect1 id="release-9-2-22">
5+
<title>Release 9.2.22</title>
6+
7+
<formalpara>
8+
<title>Release date:</title>
9+
<para>2017-08-10</para>
10+
</formalpara>
11+
12+
<para>
13+
This release contains a variety of fixes from 9.2.21.
14+
For information about new features in the 9.2 major release, see
15+
<xref linkend="release-9-2">.
16+
</para>
17+
18+
<para>
19+
The <productname>PostgreSQL</> community will stop releasing updates
20+
for the 9.2.X release series in September 2017.
21+
Users are encouraged to update to a newer release branch soon.
22+
</para>
23+
24+
<sect2>
25+
<title>Migration to Version 9.2.22</title>
26+
27+
<para>
28+
A dump/restore is not required for those running 9.2.X.
29+
</para>
30+
31+
<para>
32+
However, if you are upgrading from a version earlier than 9.2.20,
33+
see <xref linkend="release-9-2-20">.
34+
</para>
35+
36+
</sect2>
37+
38+
<sect2>
39+
<title>Changes</title>
40+
41+
<itemizedlist>
42+
43+
<listitem>
44+
<para>
45+
On Windows, retry process creation if we fail to reserve the address
46+
range for our shared memory in the new process (Tom Lane, Amit
47+
Kapila)
48+
</para>
49+
50+
<para>
51+
This is expected to fix infrequent child-process-launch failures that
52+
are probably due to interference from antivirus products.
53+
</para>
54+
</listitem>
55+
56+
<listitem>
57+
<para>
58+
Fix low-probability corruption of shared predicate-lock hash table
59+
in Windows builds (Thomas Munro, Tom Lane)
60+
</para>
61+
</listitem>
62+
63+
<listitem>
64+
<para>
65+
Avoid logging clean closure of an SSL connection as though
66+
it were a connection reset (Michael Paquier)
67+
</para>
68+
</listitem>
69+
70+
<listitem>
71+
<para>
72+
Prevent sending SSL session tickets to clients (Tom Lane)
73+
</para>
74+
75+
<para>
76+
This fix prevents reconnection failures with ticket-aware client-side
77+
SSL code.
78+
</para>
79+
</listitem>
80+
81+
<listitem>
82+
<para>
83+
Fix code for setting <xref linkend="guc-tcp-keepalives-idle"> on
84+
Solaris (Tom Lane)
85+
</para>
86+
</listitem>
87+
88+
<listitem>
89+
<para>
90+
Fix statistics collector to honor inquiry messages issued just after
91+
a postmaster shutdown and immediate restart (Tom Lane)
92+
</para>
93+
94+
<para>
95+
Statistics inquiries issued within half a second of the previous
96+
postmaster shutdown were effectively ignored.
97+
</para>
98+
</listitem>
99+
100+
<listitem>
101+
<para>
102+
Ensure that the statistics collector's receive buffer size is at
103+
least 100KB (Tom Lane)
104+
</para>
105+
106+
<para>
107+
This reduces the risk of dropped statistics data on older platforms
108+
whose default receive buffer size is less than that.
109+
</para>
110+
</listitem>
111+
112+
<listitem>
113+
<para>
114+
Fix possible creation of an invalid WAL segment when a standby is
115+
promoted just after it processes an <literal>XLOG_SWITCH</> WAL
116+
record (Andres Freund)
117+
</para>
118+
</listitem>
119+
120+
<listitem>
121+
<para>
122+
Fix <systemitem>SIGHUP</> and <systemitem>SIGUSR1</> handling in
123+
walsender processes (Petr Jelinek, Andres Freund)
124+
</para>
125+
</listitem>
126+
127+
<listitem>
128+
<para>
129+
Fix unnecessarily slow restarts of <application>walreceiver</>
130+
processes due to race condition in postmaster (Tom Lane)
131+
</para>
132+
</listitem>
133+
134+
<listitem>
135+
<para>
136+
Fix cases where an <command>INSERT</> or <command>UPDATE</> assigns
137+
to more than one element of a column that is of domain-over-array
138+
type (Tom Lane)
139+
</para>
140+
</listitem>
141+
142+
<listitem>
143+
<para>
144+
Move autogenerated array types out of the way during
145+
<command>ALTER ... RENAME</> (Vik Fearing)
146+
</para>
147+
148+
<para>
149+
Previously, we would rename a conflicting autogenerated array type
150+
out of the way during <command>CREATE</>; this fix extends that
151+
behavior to renaming operations.
152+
</para>
153+
</listitem>
154+
155+
<listitem>
156+
<para>
157+
Ensure that <command>ALTER USER ... SET</> accepts all the syntax
158+
variants that <command>ALTER ROLE ... SET</> does (Peter Eisentraut)
159+
</para>
160+
</listitem>
161+
162+
<listitem>
163+
<para>
164+
Properly update dependency info when changing a datatype I/O
165+
function's argument or return type from <type>opaque</> to the
166+
correct type (Heikki Linnakangas)
167+
</para>
168+
169+
<para>
170+
<command>CREATE TYPE</> updates I/O functions declared in this
171+
long-obsolete style, but it forgot to record a dependency on the
172+
type, allowing a subsequent <command>DROP TYPE</> to leave broken
173+
function definitions behind.
174+
</para>
175+
</listitem>
176+
177+
<listitem>
178+
<para>
179+
Reduce memory usage when <command>ANALYZE</> processes
180+
a <type>tsvector</> column (Heikki Linnakangas)
181+
</para>
182+
</listitem>
183+
184+
<listitem>
185+
<para>
186+
Fix unnecessary precision loss and sloppy rounding when multiplying
187+
or dividing <type>money</> values by integers or floats (Tom Lane)
188+
</para>
189+
</listitem>
190+
191+
<listitem>
192+
<para>
193+
Tighten checks for whitespace in functions that parse identifiers,
194+
such as <function>regprocedurein()</> (Tom Lane)
195+
</para>
196+
197+
<para>
198+
Depending on the prevailing locale, these functions could
199+
misinterpret fragments of multibyte characters as whitespace.
200+
</para>
201+
</listitem>
202+
203+
<listitem>
204+
<para>
205+
Use relevant <literal>#define</> symbols from Perl while
206+
compiling <application>PL/Perl</> (Ashutosh Sharma, Tom Lane)
207+
</para>
208+
209+
<para>
210+
This avoids portability problems, typically manifesting as
211+
a <quote>handshake</> mismatch during library load, when working with
212+
recent Perl versions.
213+
</para>
214+
</listitem>
215+
216+
<listitem>
217+
<para>
218+
In <application>psql</>, fix failure when <command>COPY FROM STDIN</>
219+
is ended with a keyboard EOF signal and then another <command>COPY
220+
FROM STDIN</> is attempted (Thomas Munro)
221+
</para>
222+
223+
<para>
224+
This misbehavior was observed on BSD-derived platforms (including
225+
macOS), but not on most others.
226+
</para>
227+
</listitem>
228+
229+
<listitem>
230+
<para>
231+
Fix <application>pg_dump</> to not emit invalid SQL for an empty
232+
operator class (Daniel Gustafsson)
233+
</para>
234+
</listitem>
235+
236+
<listitem>
237+
<para>
238+
Fix <application>pg_dump</> output to stdout on Windows (Kuntal Ghosh)
239+
</para>
240+
241+
<para>
242+
A compressed plain-text dump written to stdout would contain corrupt
243+
data due to failure to put the file descriptor into binary mode.
244+
</para>
245+
</listitem>
246+
247+
<listitem>
248+
<para>
249+
Fix <function>pg_get_ruledef()</> to print correct output for
250+
the <literal>ON SELECT</> rule of a view whose columns have been
251+
renamed (Tom Lane)
252+
</para>
253+
254+
<para>
255+
In some corner cases, <application>pg_dump</> relies
256+
on <function>pg_get_ruledef()</> to dump views, so that this error
257+
could result in dump/reload failures.
258+
</para>
259+
</listitem>
260+
261+
<listitem>
262+
<para>
263+
Fix dumping of function expressions in the <literal>FROM</> clause in
264+
cases where the expression does not deparse into something that looks
265+
like a function call (Tom Lane)
266+
</para>
267+
</listitem>
268+
269+
<listitem>
270+
<para>
271+
Fix <application>pg_basebackup</> output to stdout on Windows
272+
(Haribabu Kommi)
273+
</para>
274+
275+
<para>
276+
A backup written to stdout would contain corrupt data due to failure
277+
to put the file descriptor into binary mode.
278+
</para>
279+
</listitem>
280+
281+
<listitem>
282+
<para>
283+
Fix <application>pg_upgrade</> to ensure that the ending WAL record
284+
does not have <xref linkend="guc-wal-level"> = <literal>minimum</>
285+
(Bruce Momjian)
286+
</para>
287+
288+
<para>
289+
This condition could prevent upgraded standby servers from
290+
reconnecting.
291+
</para>
292+
</listitem>
293+
294+
<listitem>
295+
<para>
296+
Always use <option>-fPIC</>, not <option>-fpic</>, when building
297+
shared libraries with gcc (Tom Lane)
298+
</para>
299+
300+
<para>
301+
This supports larger extension libraries on platforms where it makes
302+
a difference.
303+
</para>
304+
</listitem>
305+
306+
<listitem>
307+
<para>
308+
Fix unescaped-braces issue in our build scripts for Microsoft MSVC,
309+
to avoid a warning or error from recent Perl versions (Andrew
310+
Dunstan)
311+
</para>
312+
</listitem>
313+
314+
<listitem>
315+
<para>
316+
In MSVC builds, handle the case where the <application>openssl</>
317+
library is not within a <filename>VC</> subdirectory (Andrew Dunstan)
318+
</para>
319+
</listitem>
320+
321+
<listitem>
322+
<para>
323+
In MSVC builds, add proper include path for <application>libxml2</>
324+
header files (Andrew Dunstan)
325+
</para>
326+
327+
<para>
328+
This fixes a former need to move things around in standard Windows
329+
installations of <application>libxml2</>.
330+
</para>
331+
</listitem>
332+
333+
<listitem>
334+
<para>
335+
In MSVC builds, recognize a Tcl library that is
336+
named <filename>tcl86.lib</> (Noah Misch)
337+
</para>
338+
</listitem>
339+
340+
</itemizedlist>
341+
342+
</sect2>
343+
</sect1>
344+
4345
<sect1 id="release-9-2-21">
5346
<title>Release 9.2.21</title>
6347

0 commit comments

Comments
 (0)
0