Mar
29
2009
I posted an earlier version of this on the Puppet mailing list recently; it seemed worth expanding here. An Ideal World In an ideal world, for each piece of Linux software I use, a very recent version would be “in the box” in the distribution package repositories, for every distro and distro release I use. [...]
Tags: linux, sysadmin, top
Jan
30
2009
A while back I wrote about setting up DRBD on Ubuntu. It is considerably simpler now: you don’t need to build the module anymore, a reasonably recent version is already in the box. You should still read the full directions at the DRBD web site, but to get it going, you only need to configure [...]
Tags: database, linux, sysadmin, ubuntu
Dec
05
2008
I recently needed to move a large number of files (millions) in a deep directory structure, into another similar directory structure, “merging” the contents of each directory and creating any missing directories. This task is easily (though slowly) performed on Windows with Control-C Control-V in Explorer, but I could find no obvious way to do [...]
Tags: linux, programming
Dec
02
2008
I recently needed a file server with ample capacity, on which to store data backups. The typical data access pattern for backups is that data is written once and read rarely, so bulk backup storage has much lower performance requirements than, for example, disks used for database files. I need to store a great number [...]
Tags: hardware, linux
Oct
22
2008
pgFouine is a slick, useful, and free tool for analyzing PostgreSQL query workloads. It works without any impact on the running PostgreSQL: it analyzes the PG log output. The caveat is that it needs PG configured to write the right kind of log output. Sadly, as of version 8.3 PG has a wrinkle in how [...]
Tags: database, linux, postgresql
Oct
21
2008
At work we have a set of database machines set up so that one is the primary machine, making backups once per day, and several other machines restore this backup once per day, for development, ad hoc reporting, and other secondary purposes. We started out with an obvious approach: back up on server1, to a [...]
Tags: database, linux, postgresql, sysadmin