Monitoring PostgreSQL - Part 1
I have been a PostgreSQL Administrator since 2002 and have worked for the Fred Hutchinson Cancer Research Center since 2008. Within Fred Hutch, I am the Principal Database Administrator for SCHARP, Statistical Center for HIV/AIDS Research and Prevention.
I host the Seattle Postgres Users Group where I give many of the presentations. I have many of the presentations posted at Lloyd's Presentations I am an organizer of PostgresConf.org the largest PostgreSQL conference in the US.
In this presentation we will go over how to setup the following software to setup a monitoring solution:
- Whisper Database -- This is a specialized database for storing time related data.
- Graphite -- Graphite is used to display the data from the Whisper database.
- collectd -- collectd is used to insert data into the Whisper Database from the OS and PostgreSQL.
- Grafana -- Grafana reads Graphite and PostgreSQL directly to create comprehensive dashboards.
- 45 min
- LinuxFest Northwest 2019
- Postgres Track