Skytools 2.x patch for Postgresql 9.3.5

Skytools 2.x compiles perfectly with Postgresql 9.3.5, but when you try to ‘install’ the ticker with the pgqadm.py command, you will receive a strange error. After searching around on the Internet, it seems that when you compile software with Postgresql 9.3.5, you will need to add an extra library when using ”GETSTRUCT”. The error message: […]

Postgresql: Monitor unused indexes

Working on large database systems, with many tables and many indexes, it is easy to loose the overview on what is actually being used and what is just consuming unwanted disk space. If indexes are not closely monitored, they could end up using undesired space and moreover, they will consume unnecessary CPU cycles. Statistics about […]

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 type has been introduced: JSON. Together with this new data type, new functions were also introduced. These new features now simply for instance saving web forms in your Postgresql database. Or actually any kind of dynamic […]

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 on the slave). The script will report how many bytes the slave server is behind, and how many seconds ago the last replay of data occurred. The script must be executed as ‘postgres’ user. #!/bin/bash # $Id: […]