ads' corner

Reversing pg_rewind into the future

During Nordic PGDay 2015, I attended Heikki’s talk about “pg_rewind”. Someone in the audience asked, if it’s possible to roll a PostgreSQL database forward, ahead of the master. The answer was that currently it’s not possible, but there is no technical reason why this should not work.

So I decided to have a look. Turns out, it’s surprisingly easy to do.


Autostart XEN Domains

When using XEN you can start virtual machines using xm create. However after rebooting the host machine, the virtual machines are not started automatically. This minor problem is easy to solve. Let’s say the configuration for the virtual machine is in /etc/xen/pluto.cfg:


Chemnitz Linux Days 2013

Chemnitz Linux Days is one of the main Open Source and Linux conferences in Germany, for the 15th consecutive year now. And personally it’s one of my favourite conferences.


Greenplum Community Edition - Connections from the host system into the virtual machine

If you download the Greenplum Community Edition (GP CE) from the Greenplum website and if you want to connect tools like pgAdminIII from your host machine to the database inside the virtual machine, you have to disable the firewall. The CE is installed on CentOS and by default the firewall is enabled and blocks connections from outside to most ports.

Here are the steps which are required to disable the firewall:


PostgreSQL @ Chemnitz Linux Days 2010

Like the last years the PostgreSQL User Group Germany was present with a booth at Chemnitz Linux Days 2010, one of the big open source and community events in germany.


PostgreSQL @ CeBIT 2010

The PostgreSQL User Group Germany were given the opportunity to have a booth at CeBIT 2010 and present the project. CeBIT is a very big IT-related exhibition and takes place in Hannover, Germany.


PostgreSQL stand at Chemnitz Linux Days 2010

The German PostgreSQL User Group will have a stand at Chemnitz Linux Days 2010.


Thunderbird Lightning: cannot add new calendar

If the calendar plugin Thunderbird Lightning stops working after a system upgrade (Ubuntu 8.04 -> 9.10 in my case), just reinstall the libstdc++5 library. Before installing the library you have to deinstall the plugin from Thunderbird and reinstall it afterwards.

The Thunderbird behaviour is a bit curious: the calendar and todo tabs are shown, but all previously defined calendars are missing. In addition it is not possible to add new calendars, these options are greyed out.


Include and exclude latex-beamer frames

For my slides I sometimes want to disable parts of the presentation, as example: if the operating system is Linux, I don’t need Solaris installation instructions. The \ifthenelse{<condition>}{...true...}{...false...} from the ifthen package works very well for normal frames, but it fails if there are examples (verbatim environment) in the code.


Probleme in der Wolke (aka: Backup in the Cloud)

Als langjähriger Palm-Anwender hat es mich sehr gefreut, vor einiger Zeit die Ankündigungen zum Palm Pre zu lesen. Ein neues Gerät, die Optik sah gut aus und außerdem sollte ein Linux drunter laufen. Was will man mehr?