Teaching the next generation

Many know that my son has been helping administrate a Minecraft server.  This server has enough people, that administrating the server means working at the Linux prompt level, looking at top output, editing configuration files, restarting application processes when the watchdog process fails, etc.  He also deals with the end users, helping them use the…

Continue reading

casitconf’13 discount rate extended a few days

An impressive number of registrations over the past few days has prompted us to extend early bird pricing through Monday, March 4th. Save as much as $75 over at-the-door pricing by registering before 11:59pm Monday evening! If you’re visiting Seattle from out of town, don’t forget to make your hotel reservations by phone and be…

Continue reading

Making graphs in the Postgres client shell

Here is an example of feeding query output into gnuplot without leaving psql: # psql -U postgres psql (8.4.15) Type “help” for help. postgres=# t Showing only tuples. postgres=# a Output format is unaligned. postgres=# f ‘ ‘ Field separator is ” “. postgres=# select * from example; 1 1 2 2 3 3 4…

Continue reading

Registration for casitconf’13 is open

The moment you've all been waiting for is here! Registration for the 2013 Cascadia IT Conference is now open! The schedules for tutorials and technical sessions are posted. Full descriptions of all the tech talks will be posted in the next few days. Please share the news with anyone you think might be interested.

Using IRC – a write-up for my developers

[I wrote this for our developers to help them get on IRC.] You can get support from the open source community over IRC (Internet Relay Chat), live text-based group chat. I installed the “irssi” package from the RPMforge repository to get on IRC. Using IRC ======= Start irssi: irssi Connect to the Freenode IRC network,…

Continue reading

Postgres 9.2 allows on-the-fly insight into query performance with pg_stat_statements

Postgres 9.2 includes a very handy pg_stat_statements shared library and extension which allows immediate insight into query performance. Installation: ———— 1. Add to postgresql.conf: shared_preload_libraries = ‘pg_stat_statements’ 2. Restart PostgreSQL. 3. Run create extension pg_stat_statements; to have access to the statistics and the helper functions. Use — — reset statistics select pg_stat_statements_reset(); — which query…

Continue reading