Pgwatch: PostgreSQL Monitoring Solution

a year ago

Run the latest demo Docker image with Grafana on port 3000, administrative web UI on port 8080, and internal database on port 5432.
Use `docker run` command with specific ports and environment variables to start the container.
Access Grafana as admin (admin/pgwatchadmin) to view or create dashboards.
For production, use the cybertecpostgresql/pgwatch Docker image.
Clone the repository and use Docker compose for quick setup with services like configuration database, monitoring agent, and Grafana.
Add a test database for monitoring using WebUI or command line script.
Emulate workload with `docker/compose.pgbench.sh` to generate test data and transactions.
pgAdmin uses port 80; modify `docker/compose.pgadmin.yml` to change the port.
Access pgAdmin4 at localhost with credentials [email protected]/admin to inspect the pgwatch database.
Restart the pgwatch agent after code changes with a rebuild and relaunch command.
Monitor logs in detached mode using `docker compose logs` commands.
Feedback and contributions are welcome.

Hasty Briefsbeta