Grafana with pg_stat_statements

Grafana with pg_stat_statements

Grafana with pg_stat_statements In this post i describe an option to visualize the statement statistics collected by pg_stat_statments in Grafana. When using PostgreSQL you probably already know the fabulous pg_stat_statements extension. For those who don’t know it,...
Partial Restore of a Table

Partial Restore of a Table

Partial Restore of a Table Consider a case were you recognized that some entries in your production database are missing or corrupted. If you are lucky enough you have a recent backup in place, but now the question arises, how can we only restore the missing entries...
GDPR Database Security – SSL Encryption

GDPR Database Security – SSL Encryption

GDPR Database Security – SSL Encryption The General Data Protection Regulation (GDPR) is a regulation to strengthen and unify the data protection for people living in the European Union. It will become mandatory in May 2018 for all companies working with...
File Transfer between Ansible Nodes

File Transfer between Ansible Nodes

File Transfer between Ansible Nodes Have you ever wanted to transfer files between different Ansible nodes and i do not mean between the control machine and the managed nodes? Then this post might be helpful for you.  Instead of using the synchronize module or copying...
Monitoring PostgreSQL with Sensu

Monitoring PostgreSQL with Sensu

Monitoring PostgreSQL with Sensu Sensu is a relative new Player in the Monitoring World. Upon now i’ve monitored my PostgreSQL Infrastructurs with Nagios or Icinga 2, now it’s time to see what Sensu offers. Here i will share some experience from a test i run today. ...