PostgreSQL Monitoring: pgwatch and Grafana

A streamlined environment for monitoring PostgreSQL databases using pgwatch and visualizing the metrics with Grafana.

Prerequisites

• Docker
• Docker Compose

Installation and Setup

1. Clone the repository:

git clone https://github.com/darseen/pgwatch.git
cd pgwatch

2. Start the services using docker compose:

docker compose up

Accessing the Services

• Grafana: http://localhost:3000

  • Default credentials: admin / admin

• pgwatch Web UI: http://localhost:8080

  • Default credentials: admin / admin

Configuration

1. Open the pgwatch Web UI.

2. Add your target PostgreSQL database instances by providing their connection details.

3. Open Grafana, navigate to the dashboards section, and use the pre-loaded pgwatch dashboards to monitor your database metrics.

Persistence and Environment Variables

Data persistence and configuration are handled via the compose.yaml file. You can modify the mapped volumes or environment variables directly in the file to change default ports, set secure passwords, or adjust resource limits.

License

This project is licensed under the MIT License.