Software, Business, and Life
Dec 16 2009
I suppose there have been hiring companies with wildly unrealistic cost expectations forever; the internet just makes it more visible. Take, for example, this job post for PostgreSQL expert, which I republish here for criticism and comment, anonymized:
We are looking for a postgre expert with indepth Oracle skill to help with the following project:
1) migrate [...]
Comments Off
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 it [...]
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 it [...]
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 file [...]
