Browsing Tag
Postgresql
6 posts
Deploy a PostgreSQL database with an initial schema using Ansible
Ansible is a great automation tool to manage operating systems, but also to manage database like PostgreSQL. Many…
Perl: Create schema backups in PostgreSQL
At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema…
Postgresql: Monitor sequence scans with Perl
Not using indexes or huge tables without indexes, can have a very negative impact on the duration of…
Postgresql: Monitor unused indexes
Working on large database systems, with many tables and many indexes, it is easy to loose the overview…
Postgresql 9.3: Creating an index on a JSON attribute
Recently I’ve discovered some very interesting new features in the PostgreSQL 9.3 database.First of all, a new data…
PostgreSQL 9.2 Master – Slave Monitoring
Nagios plugin script written in Bash to check the master-slave replication in PostgreSQL (tested on PostgreSQL 9.2.4) (executed…