Thread: Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

From
Thomas Poty
Date:
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

Re: Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

From
Adrian Klaver
Date:
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