Contact
Offices

Blog

news rss

Joseph Conway
Frequently when dealing with parametric data, you need to "roll up" the data in summary fashion as it ages in order to reduce the volume kept on hand, or maybe because the summary statistics are what really interests you. There are several ways to do that, and this post highlights four different...
Joseph Conway
Someone posted a dilemma to the pgsql-sql list today that involved many if not all of his sequences getting out of sync with their respective "serial" columns. In other words, something like "SELECT max(id) FROM sometable" yields 42, but the sequence nextval for sometable.id is currently set to 36...
Joseph Conway
I was given a Postgres database dump to analyze today created by "pg_dump -Fc". The source database included PostGIS 1.3.x extensions. I'm not sure if this is standard with PostGIS, but the related database objects were all dumped with a hard-coded library path, specifically /usr/lib/postgresql/8.3...
Martin Zobel-Helas
The text editor vim offers several tools for automation. This howto describes a way to auto-include text modules when creating new files. Often during programming or administration you need the same text modules again and again. The editor vim is very helpful here, as it can detect a file type...
Bernd Helmle
The PostgreSQL developers' community recently published the first Beta version of the new 9.0 release. Over 200 new functions and improvements feature in this new version. With this new release , PostgreSQL now amongst other features claims an inbuilt replication solution as well as the ability to...
Roland Wolters
Following our earlier introduction to RHCS we now present a real world example: the installation of RHCS with Debian to provide certain virtual machines as services. Our RHCS overview already explained the basics of RHCS. This time we will take two hosts with shared storage and provide KVM guests...
Michael Banck
In May, Consultants from credativ GmbH will be holding a 3 day advanced system and network administration workshop at the Open Source School in Munich. Training specifics (subject to modifications!): Kerberos : This training covers the Kerberos authentification protocol, which can handle a range of...
Bernd Zeimetz
Lighttpd is a web server with a fast growing user base. This howto will demonstrate how redirects can be done based on the language of the user's browser. While migrating from our old blogging software to Movable Type we decided it would be a good idea to show the blog's welcome message in English...
Bernd Helmle
The OOM-Killer can cause nasty surprises on machines with a heavy memory load; processes are cancelled or terminated without warning. Fortunately, this behaviour can be adjusted with some clever kernel tweaks. Administrators of Linux machines with a very high RAM-Usage are sometimes faced with a...
Roland Wolters
This week, credativ launches its Open Source Support Card. With this card Open Source Support can be bought at a fixed price - without a binding contract. After a long preparation phase we are now offering our trusted services in a new, simple format; with the Open Source Support Card you get a...