[google-cloud-sql-discuss] Re: pgstattuple only allowed by superuser

Hi,

Thanks for this answer that help understanding the same issue I encountered.

If pgstattuple is not usable why letting it available ? 

What about removing from the available extensions list all that we can't use ?

postgres=> select * from pg_available_extensions where name ='pgstattuple';

    name     | default_version | installed_version |           comment           

-------------+-----------------+-------------------+-----------------------------

 pgstattuple | 1.5             | 1.5               | show tuple-level statistics

(1 row)

Best

On Friday, May 22, 2020 at 5:53:09 AM UTC+2 Mary (Cloud Platform Support) wrote:

Hello Ben,

Pgstattuple was deprecated in November, 2018 due to compatibility and functionality issues which is why it no longer appears on the supported extensions page but is still listed in the release notes of June 2017 when it was first introduced.

On Friday, May 15, 2020 at 2:34:14 PM UTC-4, Ben Perlman wrote:

It says that pgstattuple is supported here: https://cloud.google.com/sql/docs/postgres/release-notes#June_01_2017
Any ideas why its not actually on the supported extension page? 

On Friday, April 5, 2019 at 11:16:46 AM UTC-4, George (Cloud Platform Support) wrote:

Hello Zsolt, 

This behavior should not appear as unexpected: any features requiring superuser access are not supported. An exception to this rule is made for the CREATE EXTENSION statement, but only for supported extensions, as stated on the "Cloud SQL Features" page. pgstattuple does not fall under this category, as it does not appear on the list of supported extensions. You can check the status of that list on the "PostgreSQL Extensions" page. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/dd35376b-9923-412e-9b63-c435174e250fn%40googlegroups.com.