Browsing Tag
SysAdmin
25 posts
Perl: Create schema backups in PostgreSQL
At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema…
Monitor running processes with Perl
Update: This article is updated thanks to Colin Keith his excellent comment. I was extremely inspired by it…
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…
OpenSSH 6.2.x and LDAP authentication
Since the release of OpenSSH 6.2, two new configuration parameters have been added: AuthorizedKeysCommand AuthorizedKeysCommandUser These parameters allow…
Backup to free Hetzner FTP
If you have a hosting account at Hetzner with free backup space, you can not access this backup…
Check if a NFS share is mounted
Below is a small Perl example how to check for NFS mounted shares on a Linux host. The…
Secure MySQL Backups with GnuPG
One way to secure your MySQL backups, is to encrypt the backup file using PGP/GnuPG. Of course you…
Resize a LVM partition in a Debian VMWare VM
It can happen that a VMWare virtual machine (VM) runs out of space after a certain amount of…
dmesg with human readable timestamps
When you are not using Debian unstable or some kind of Linux distro that hasn’t got the latest…