Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

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