PostgreSQL Performance Monitoring and Alerting
An essential task of a DBA is to monitor PostgreSQL for faults. The primary reason to monitor PostgreSQL are availability, system optimization, identify performance problems, business process improvement, and capacity planning. There are many tools available to help monitor PostgreSQL at scale. While some of these tools are free, most are paid and more suitable for enterprise deployment environments. To monitor PostgreSQL effectively, DBA's and system administrators use tools to create custom alerts and notifications that can provide live and proactive alerts for faults. In this archive, once can find tips, tricks, and tutorials to monitor PostgreSQL.
How To Monitor PostgreSQL Like a Pro!
In this post, we dig into why it's essential to monitor Postgres, and how to do it effectively.
Tools for Monitoring Postgres Databases
Users depend on databases to carry out meaningful work. Whether it’s connected to a mission-critical application or helping a single user carry out a very specific task, databases must be well-maintained in order to provide high performance. Proactiv ...
EnterpriseDB Updates Tools, and Enhances Security and Alerting
Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available supportive infrastructure. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools ...
What Happens if You Don’t Monitor Your PostgreSQL Database Effectively?
A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job becomes even more crucial. Not monitoring your databases and system effectively may lead to a severe ca ...
Monitoring approach for Streaming Replication with Hot Standby in PostgreSQL 9.3.
*/ The people using PostgreSQL and the Streaming Replication feature seem to ask many of the same questions: 1. How best to monitor Streaming Replication? 2. What is the best way to do that? 3. Are there alternatives, when monitoring on Standby, to ...
Monitoring Postgres from the Command Line
You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for an idle Postgres server: postgres 2544 2543 0 10:47 ? 00:00:00 /u/pgsql/bin/postmaster ...
Monitor CPU and MEMORY percentage used by each process in PostgreSQL/PPAS 9.1
*/ PostgreSQL has pg_stat_activity view which can be use to get the session details. This view gives following information: 1. datid: database OID 2. datname: database name 3. procpid: process ID 4. usesysid: user OID 5. usename: user name 6. appl ...
Going after load spikes and performance lulls with Postgres Enterprise Manager
Bruce Momjian recently did a blog on Postgres Monitoring tools. I want to point out a unique and useful feature of Postgres Enterprise Manager from EnterpriseDB. I frequently hear from prospects that they would like us to help them debug periodic per ...
EnterpriseDB integrates Backup and Recovery tools with Postgres Enterprise Manager for superior database management
This post discusses the EDB Backup and Recovery Tool integration into EDB Postgres Enterprise Manager.
Postgres Enterprise Manager Architecture
Postgres Enterprise Manager or PEM is a comprehensive monitoring and management solution for PostgreSQL and EDB Postgres Advanced Server (EPAS) from EnterpriseDB. It is a distributed application with a number of components that can be installed in ma ...
Monitoring Amazon PostgreSQL RDS with PEM version 6.0
The EDB Postgres™ Enterprise Manager is an enterprise management tool designed to tune, manage, and monitor a large number of Postgres deployments on servers on-premises or spread out across geographical boundaries. It is the cornerstone of the Manag ...
Monitoring in PostgreSQL 9.6
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and chew gum at the same time" Part 2 - Monitoring VACUUM progress monitoring Wait monitoring Part 3 ...
How to replace Postgres Enterprise Manager self-signed certificates with certificates provided by Certificate Authority (CA)
This article provides instructions for how to replace self-signed certificates for Postgres Enterprise Manager with authorized certificates issued by Certificate Authority.
Extending PostgreSQL Monitoring in Postgres Enterprise Manager by Creating Custom Probes
This article defines a probe and provides instructions for creating custom probes for PostgreSQL using EDB Postgres Enterprise Manager (PEM).
How to Replacing httpd self signed SSL certificates with trusted CA signed certificates in Postgres Enterprise Manager
In this blog post we will go trough the steps to replace httpd self signed SSL certificates with trusted CA signed cerficates in Postgres Enterprise Manager
Integrating Nagios with EDB Postgres Enterprise Manager
A cornerstone of the Management Suite in the EDB Postgres Platform is EDB Postgres Enterprise Manager (PEM). The suite provides key management, monitoring, and development capabilities. PEM is designed for monitoring and managing both small and large ...
Be the Master of All You Survey with Postgres Enterprise Manager 5.0
With the most recent release of Postgres Plus Advanced Server 9.4, EnterpriseDB (EDB) has also upgraded our database enterprise management console, Postgres Enterprise Manager (PEM). The new PEM 5.0 delivers all the enterprise-class tools necessary f ...
Postgres Enterprise Manager; I love it when a plan comes together
After 9 months of heads-down work, I'm glad to finally be able to talk about the project I and a number of colleagues here at EnterpriseDB have been working on... Introducing Postgres Enterprise Manager! Postgres Enterprise Manager, or PEM as we tend ...