Thread: Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update
Hi,
I am about to upgrade from 9.6.10 to 10.6 .
I read, in the release notes of the 9.6.11 and of the 10.6, an "alter extension pg_stat_statements update" must be done.
So, after my upgrade, must the update of pg_statements be done ?
Thanks
Thomas
On 1/30/19 7:14 AM, Thomas Poty wrote: > Hi, > > I am about to upgrade from 9.6.10 to 10.6 . > I read, in the release notes of the 9.6.11 and of the 10.6, an "alter > extension pg_stat_statements update" must be done. > > So, after my upgrade, must the update of pg_statements be done ? Per the notes: https://www.postgresql.org/docs/10/release-10-6.html#id-1.11.6.5.4 "In contrib/pg_stat_statements, disallow the pg_read_all_stats role from executing pg_stat_statements_reset() (Haribabu Kommi) pg_read_all_stats is only meant to grant permission to read statistics, not to change them, so this grant was incorrect. To cause this change to take effect, run ALTER EXTENSION pg_stat_statements UPDATE in each database where pg_stat_statements has been installed. " So if you have the extension installed then yes. You can check in each database, using the psql command: \dx > > Thanks > > Thomas -- Adrian Klaver adrian.klaver@aklaver.com