Hello, Any one can help me for my problem on postgresql using pmm-admin, I got the error log, 2021-01-11 13:25:00.013 WIB [19845] pmm@postgres ERROR: relation "pg_stat_statements" does not exist at character 753 2021-01-11 13:25:00.013 WIB [19845] pmm@postgres STATEMENT: SELECT /* pmm-agent:pgs…

Hello @Gunks535 , It’s likely that you need to run CREATE EXTENSION pg_stat_statements; in the postgres database that’s used by PMM to connect. Connecting to postgres db the default (and only, afaik) behavior for PMM at this point, and you can additionally see that in your error log showing pmm@post…

Pmm@postgres ERROR: relation "pg_stat_statements" does not exist at character 753

PostgreSQL PostgreSQL General Discussion

Gunks535 January 13, 2021, 1:26am 5

That’s it!
I don’t recognize if by default postgresql by default is postgres user, and the root user was created by postgres user, lol
Thank you for your support, we can close it now.,

3 Likes

Regarding for PostgreSQL Adminitration

Topic		Replies	Views
PMM Query Analytics for Postgres & Aurora Postgres PMM 1.x	2	1591	October 23, 2019
Sorry, no examples found for this query in Example tab(postgres) PMM unofficial Dashboards and Plugins pmm	4	1288	July 4, 2021
Adding PostgreSQL Queries Overview Dashboards to the PMM Plugin https://www.percona.com/blog/2019/04/23/adding-postgresql-queries-overview-dashboards-to-the-pmm-plugin/ Percona Monitoring and Management (PMM) closed-no-reply	0	522	March 30, 2022
ERROR: function pg_stat_monitor_version() does not exist at character 38 pmm , percona , postgres , postgresql	1	2085	September 5, 2023
Does pg_stat_statements extension view needs to be created on all databases PMM 2.x new-release , pmm-doc , postgresql	4	383	August 14, 2024

Pmm@postgres ERROR: relation "pg_stat_statements" does not exist at character 753

Related topics