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 … Continue reading
Tag Archives: Dev
At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema to a compressed file and which was able to create weekly and daily backups. The backups had to be full backups each … Continue reading
Update: This article is updated thanks to Colin Keith his excellent comment. I was extremely inspired by it Maintaining a large number of servers cannot be done without proper programming skills. Each good system administrator must therefor make sure he … Continue reading
Not using indexes or huge tables without indexes, can have a very negative impact on the duration of a SQL query. The query planner will decide to make a sequence scan, which means that the query will go through the … Continue reading
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 … Continue reading
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 … Continue reading
Recently I’ve stumbled on a pretty cool OpenSource project called ”datatables” (http://datatables.net/), which allows to easily create tables in HTML that can be: sorted searched paginated scroll infinitely themed … And most important: it’s for free! I’ve always wanted to … Continue reading
The Google API GeoChart Map (https://developers.google.com/chart/interactive/docs/gallery/geochart) is pretty nice widget to generate nice maps based on certain values. It has quite a lot of features and it is very easy to use. Before we look at the Google API for … Continue reading
A secure and very random password generator module written in Perl. It can be used to generate passwords or unique strings which can be used in sorts of operations. The default character set is alpha-numerical based, but can be set … Continue reading
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 … Continue reading