Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit334b82c

Browse files
committed
Second pass on 9.6.3 release notes.
Improve description of logical decoding snapshot issues, per suggestionfrom Petr Jelinek. Mention possible need to re-sync logical replicasas a post-upgrade task. Minor copy-editing for some other items.
1 parenta9c6d70 commit334b82c

File tree

1 file changed

+56
-44
lines changed

1 file changed

+56
-44
lines changed

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

Lines changed: 56 additions & 44 deletions
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,12 @@
2323
</para>
2424

2525
<para>
26-
However, if you are upgrading from a version earlier than 9.6.2,
26+
However, if you are using third-party replication tools that depend
27+
on <quote>logical decoding</>, see the first changelog entry below.
28+
</para>
29+
30+
<para>
31+
Also, if you are upgrading from a version earlier than 9.6.2,
2732
see <xref linkend="release-9-6-2">.
2833
</para>
2934
</sect2>
@@ -35,6 +40,40 @@
3540

3641
<listitem>
3742
<!--
43+
Author: Andres Freund <andres@anarazel.de>
44+
Branch: master [2bef06d51] 2017-04-27 13:13:36 -0700
45+
Branch: REL9_6_STABLE [28afff347] 2017-04-27 13:13:36 -0700
46+
Branch: REL9_5_STABLE [47f896b5c] 2017-04-27 13:13:37 -0700
47+
Branch: REL9_4_STABLE [5da646138] 2017-04-27 13:13:37 -0700
48+
Branch: master [56e19d938] 2017-04-27 15:29:15 -0700
49+
Branch: REL9_6_STABLE [29e8c881d] 2017-04-27 15:29:33 -0700
50+
Branch: REL9_5_STABLE [54270d7eb] 2017-04-27 15:29:43 -0700
51+
Branch: REL9_4_STABLE [b6ecf26cc] 2017-04-27 15:29:52 -0700
52+
-->
53+
<para>
54+
Fix possibly-invalid initial snapshot during logical decoding
55+
(Petr Jelinek, Andres Freund)
56+
</para>
57+
58+
<para>
59+
The initial snapshot created for a logical decoding replication slot
60+
was potentially incorrect. This could cause third-party tools that
61+
use logical decoding to copy incomplete/inconsistent initial data.
62+
This was more likely to happen if the source server was busy at the
63+
time of slot creation, or if another logical slot already existed.
64+
</para>
65+
66+
<para>
67+
If you are using a replication tool that depends on logical decoding,
68+
and it should have copied a nonempty data set at the start of
69+
replication, it is advisable to recreate the replica after
70+
installing this update, or to verify its contents against the source
71+
server.
72+
</para>
73+
</listitem>
74+
75+
<listitem>
76+
<!--
3877
Author: Robert Haas <rhaas@postgresql.org>
3978
Branch: master [87f998203] 2017-03-14 11:51:11 -0400
4079
Branch: REL9_6_STABLE [36fcb36b8] 2017-03-14 11:52:27 -0400
@@ -81,33 +120,6 @@ Branch: REL9_2_STABLE [952e33b05] 2017-04-23 13:10:58 -0400
81120

82121
<listitem>
83122
<!--
84-
Author: Andres Freund <andres@anarazel.de>
85-
Branch: master [2bef06d51] 2017-04-27 13:13:36 -0700
86-
Branch: REL9_6_STABLE [28afff347] 2017-04-27 13:13:36 -0700
87-
Branch: REL9_5_STABLE [47f896b5c] 2017-04-27 13:13:37 -0700
88-
Branch: REL9_4_STABLE [5da646138] 2017-04-27 13:13:37 -0700
89-
Branch: master [56e19d938] 2017-04-27 15:29:15 -0700
90-
Branch: REL9_6_STABLE [29e8c881d] 2017-04-27 15:29:33 -0700
91-
Branch: REL9_5_STABLE [54270d7eb] 2017-04-27 15:29:43 -0700
92-
Branch: REL9_4_STABLE [b6ecf26cc] 2017-04-27 15:29:52 -0700
93-
-->
94-
<para>
95-
Fix possibly-corrupt initial snapshot during logical decoding
96-
(Petr Jelinek, Andres Freund)
97-
</para>
98-
99-
<para>
100-
If a logical decoding replication slot was created while another slot
101-
already exists, it was initialized with a potentially-corrupted
102-
snapshot, allowing wrong data to be returned during decoding.
103-
The time window during which this snapshot continued to be used
104-
depended on how busy the server was; under low load it would be hard
105-
to see any problem.
106-
</para>
107-
</listitem>
108-
109-
<listitem>
110-
<!--
111123
Author: Fujii Masao <fujii@postgresql.org>
112124
Branch: master [1d04a59be] 2017-02-22 03:11:58 +0900
113125
Branch: REL9_6_STABLE [9fab155c6] 2017-02-22 08:29:32 +0900
@@ -142,15 +154,15 @@ Branch: master [aa1351f1e] 2017-04-26 16:17:34 -0400
142154
Branch: REL9_6_STABLE [e880df25e] 2017-04-26 16:17:29 -0400
143155
-->
144156
<para>
145-
Prevent delays in postmaster's launching of parallel worker processes
146-
(Tom Lane)
157+
Prevent delays in postmaster's launching ofmultipleparallel worker
158+
processes(Tom Lane)
147159
</para>
148160

149161
<para>
150162
There could be a significant delay (up to tens of seconds) before
151-
satisfying a query's request for more than one worker process. On most
152-
platforms this required unlucky timing, but on some it was the typical
153-
case.
163+
satisfying a query's request for more than one worker process, or when
164+
multiple queries requested workers simultaneously. On most platforms
165+
this required unlucky timing, but on some it was the typicalcase.
154166
</para>
155167
</listitem>
156168

@@ -168,8 +180,8 @@ Branch: REL9_4_STABLE [436b560b8] 2017-04-24 12:16:58 -0400
168180
</para>
169181

170182
<para>
171-
Previously, the postmasterpartiallyupdated its state as though
172-
the process had beensuccessfullylaunched, resulting in subsequent
183+
Previously, the postmaster updated portions of its state as though
184+
the process had been launched successfully, resulting in subsequent
173185
confusion.
174186
</para>
175187
</listitem>
@@ -227,7 +239,7 @@ Branch: REL9_5_STABLE [6f0f98bb0] 2017-04-17 15:29:00 -0400
227239
<para>
228240
This optimization supposed that retrieving all columns of a tuple
229241
is inexpensive, which is true for ordinary Postgres tuples; but it
230-
might not be the caseat allfor a custom scan provider.
242+
might not be the case for a custom scan provider.
231243
</para>
232244
</listitem>
233245

@@ -271,7 +283,7 @@ Branch: REL9_2_STABLE [27a8c8033] 2017-02-12 16:05:23 -0500
271283

272284
<para>
273285
The command failed if the calling user did not currently have
274-
privileges to use the tablespacean index had been created in.
286+
<literal>CREATE</> privilege for the tablespacecontaining the index.
275287
That behavior seems unhelpful, so skip the check, allowing the
276288
index to be rebuilt where it is.
277289
</para>
@@ -289,7 +301,7 @@ Branch: REL9_2_STABLE [f60f0c8fe] 2017-04-28 14:55:42 -0400
289301
-->
290302
<para>
291303
Fix <command>ALTER TABLE ... VALIDATE CONSTRAINT</> to not recurse
292-
to child tablesif the constraint is marked <literal>NO INHERIT</>
304+
to child tableswhen the constraint is marked <literal>NO INHERIT</>
293305
(Amit Langote)
294306
</para>
295307

@@ -404,7 +416,7 @@ Branch: REL9_4_STABLE [8851bcf88] 2017-04-05 23:51:28 -0400
404416
-->
405417
<para>
406418
Fix integer-overflow problems in <type>interval</> comparison (Kyotaro
407-
Horiguchi and Tom Lane)
419+
Horiguchi, Tom Lane)
408420
</para>
409421

410422
<para>
@@ -682,9 +694,9 @@ Branch: REL9_6_STABLE [4e8b2fd33] 2017-02-17 15:06:34 -0500
682694
</para>
683695

684696
<para>
685-
This resulted in <application>pg_dump</> alwaysthinking that the
686-
language had no initial privileges; since that's true for most
687-
procedural languages,bad effects from this bug are probably rare.
697+
This resulted in <application>pg_dump</> alwaysbelieving that the
698+
language had no initial privileges. Since that's true for most
699+
procedural languages,ill effects from this bug are probably rare.
688700
</para>
689701
</listitem>
690702

@@ -763,8 +775,8 @@ Branch: REL9_3_STABLE [f6cfc14e5] 2017-03-11 13:33:22 -0800
763775
Branch: REL9_2_STABLE [c4613c3f4] 2017-03-11 13:33:30 -0800
764776
-->
765777
<para>
766-
In <filename>contrib/dblink</>, avoidconnection leak when establishing
767-
a new unnamed connection (Joe Conway)
778+
In <filename>contrib/dblink</>, avoidleaking the previous unnamed
779+
connection when establishinga new unnamed connection (Joe Conway)
768780
</para>
769781
</listitem>
770782

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp