Comments on: Monitoring PostgreSQL Databases Using PMM https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/ Thu, 11 Apr 2024 22:54:06 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Avinash Vallarapu https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10972742 Tue, 29 Sep 2020 23:49:31 +0000 https://www.percona.com/blog/?p=63019#comment-10972742 Not yet. We have recently finished the development for this feature internally. I will keep the thread posted as soon as it is deployed as part of the next release.

]]> By: Sumit Aneja https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10972695 Mon, 14 Sep 2020 21:32:15 +0000 https://www.percona.com/blog/?p=63019#comment-10972695 Just checking whether this feature was implemented?

]]> By: vinay jaiswal https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10972056 Tue, 07 Apr 2020 11:06:27 +0000 https://www.percona.com/blog/?p=63019#comment-10972056 Anyone noticed PMM 2 for postgresql , db uptime is not showing correct because it display the time on the basis postgresql_exporter process (time() – process_start_time_seconds{node_name=”xxx\\.xxx\\.xxxpmm-server”,job=”postgres_exporter.*”})) . Is it bug and it designed by nature for postgresql DB .

while db uptime shows correct for mysql/MongoDB. mysql_global_status_uptime ,mongodb_instance_uptime_seconds

]]> By: janardhan https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971937 Mon, 16 Mar 2020 18:47:21 +0000 https://www.percona.com/blog/?p=63019#comment-10971937 I have added postgresql 10.6 version database(rds postgresql) in PMM but it is not showing any quires in PMM QAN.

any suggestions would be appreciated.

]]> By: GSPANN https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971833 Tue, 18 Feb 2020 08:47:41 +0000 https://www.percona.com/blog/?p=63019#comment-10971833 You may learn how to monitor MySQL database with Grafana and Prometheus. Here is the link – https://www.gspann.com/resources/blogs/mysql-database-monitoring-with-grafana-and-prometheus

]]> By: Rodrigo Buch https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971774 Tue, 04 Feb 2020 19:17:49 +0000 https://www.percona.com/blog/?p=63019#comment-10971774 I am getting the following error:

postgres @ easydocdb02: ~ $ psql -c -d pmm_user “CREATE EXTENSION pg_stat_statements”
psql: FATAL: Peer authentication failed for user “CREATE EXTENSION pg_stat_statements”

]]> By: avivallarapu https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971615 Thu, 02 Jan 2020 11:56:04 +0000 https://www.percona.com/blog/?p=63019#comment-10971615 Not yet Yogesh. But this is one of the features you will see in the future releases. Thank you for the feedback.

]]> By: Yogesh https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971380 Mon, 04 Nov 2019 16:06:49 +0000 https://www.percona.com/blog/?p=63019#comment-10971380 Is it possible to monitor replication lag and their topology using Pmm by default ?

]]> By: avivallarapu https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971375 Fri, 01 Nov 2019 12:31:14 +0000 https://www.percona.com/blog/?p=63019#comment-10971375 Thank You for reading through the blog post. This is a known bug with PMM2 that you need to have a database that is same as the monitoring user. With the next PMM release, you should see this fixed. This way you could pass any database or leave it the default (postgres). However, this dependency today should not affect any of the PMM functionalities.

]]> By: giant https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comment-10971369 Fri, 01 Nov 2019 03:20:16 +0000 https://www.percona.com/blog/?p=63019#comment-10971369 why QAN need new database then name of PMM user? is possible using other name of database for QAN?

]]>