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
ERROR: relation "pg_stat_monitor_settings" already exists PMM 2.x	1	716	April 21, 2023
Relation "pg_stat_monitor_settings" already exists Percona Monitoring and Management (PMM) pmm , percona , postgres , postgresql	4	950	May 23, 2023
PMM Query Analytics for Postgres & Aurora Postgres PMM 1.x	2	1367	October 23, 2019
[postgres] [QAN] QAN examples not found PMM 2.x pmm , postgres	3	719	September 29, 2023
ERROR: function pg_stat_monitor_version() does not exist at character 38 pmm , percona , postgres , postgresql	1	1656	September 5, 2023

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

Related Topics