File tree 2 files changed +34
-6
lines changed
2 files changed +34
-6
lines changed Original file line number Diff line number Diff line change @@ -1036,12 +1036,6 @@ Branch: REL9_3_STABLE [9f3ade1a6] 2018-08-31 20:21:30 +0300
1036
1036
</listitem>
1037
1037
1038
1038
<listitem>
1039
- <!--
1040
- Author: Michael Paquier <michael@paquier.xyz>
1041
- Branch: master [edb979766] 2018-09-25 09:55:44 +0900
1042
- Branch: REL_11_STABLE Release: REL_11_0 [a3bb831ef] 2018-09-25 09:56:41 +0900
1043
- Branch: REL_10_STABLE [90a1f9786] 2018-09-25 09:56:57 +0900
1044
- -->
1045
1039
<para>
1046
1040
In <filename>contrib/pg_stat_statements</filename>, disallow
1047
1041
the <literal>pg_read_all_stats</literal> role from
@@ -1052,6 +1046,9 @@ Branch: REL_10_STABLE [90a1f9786] 2018-09-25 09:56:57 +0900
1052
1046
<para>
1053
1047
<literal>pg_read_all_stats</literal> is only meant to grant permission
1054
1048
to read statistics, not to change them, so this grant was incorrect.
1049
+ </para>
1050
+
1051
+ <para>
1055
1052
To cause this change to take effect, run <literal>ALTER EXTENSION
1056
1053
pg_stat_statements UPDATE</literal> in each database
1057
1054
where <filename>pg_stat_statements</filename> has been installed.
Original file line number Diff line number Diff line change @@ -301,6 +301,37 @@ Branch: REL_11_STABLE [cc7f27eae] 2018-10-19 22:45:07 +0900
301
301
302
302
<listitem>
303
303
<!--
304
+ Author: Michael Paquier <michael@paquier.xyz>
305
+ Branch: master [edb979766] 2018-09-25 09:55:44 +0900
306
+ Branch: REL_11_STABLE Release: REL_11_0 [a3bb831ef] 2018-09-25 09:56:41 +0900
307
+ Branch: REL_10_STABLE [90a1f9786] 2018-09-25 09:56:57 +0900
308
+ -->
309
+ <para>
310
+ In <filename>contrib/pg_stat_statements</filename>, disallow
311
+ the <literal>pg_read_all_stats</literal> role from
312
+ executing <function>pg_stat_statements_reset()</function>
313
+ (Haribabu Kommi)
314
+ </para>
315
+
316
+ <para>
317
+ <literal>pg_read_all_stats</literal> is only meant to grant permission
318
+ to read statistics, not to change them, so this grant was incorrect.
319
+ </para>
320
+
321
+ <para>
322
+ To cause this change to take effect, run <literal>ALTER EXTENSION
323
+ pg_stat_statements UPDATE</literal> in each database
324
+ where <filename>pg_stat_statements</filename> has been installed.
325
+ (A database freshly created in 11.0 should not need this, but a
326
+ database upgraded from a previous release probably still contains
327
+ the old version of <filename>pg_stat_statements</filename>. The
328
+ <literal>UPDATE</literal> command is harmless if the module was
329
+ already updated.)
330
+ </para>
331
+ </listitem>
332
+
333
+ <listitem>
334
+ <!--
304
335
Author: Tom Lane <tgl@sss.pgh.pa.us>
305
336
Branch: master [1440c461f] 2018-11-02 18:54:00 -0400
306
337
Branch: REL_11_STABLE [df1d749a7] 2018-11-02 18:54:00 -0400
You can’t perform that action at this time.
0 commit comments