von Marco Nietz | Nov 14, 2018 | Grafana, PostgreSQL
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,...
von Marco Nietz | Feb 4, 2018 | PostgreSQL
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...
von Marco Nietz | Nov 28, 2017 | PostgreSQL
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...
von Marco Nietz | Dez 20, 2016 | Ansible
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...
von Marco Nietz | Aug 18, 2016 | PostgreSQL
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. ...