About the Site

Welcome to my web site on computers. I'm working to add more content as time allows.

Content on the website will be related mainly to Linux and data / databases (I'm currently employed as a Database Administrator (DBA) for Northwest Evaluation Association), although you will find occasional articles related to Microsoft Windows Operating Systems.

The purpose of this web site is two-fold:

About Me

Tim BruceI am a Database Administrator for NorthWest Evaluation Association (NWEA).  I work mostly with the PostgreSQL database engine although I'm also supporting both MongoDB and MySQL. I also do a limited amount of systems administration with Linux - specifically Ubuntu on my desktop and Red Hat on our servers.

While I mainly use PostgreSQL at work, my background includes Sybase, SQL Server, PostgreSQL and MySQL and I use PostgreSQL at home.

Presentation on collectd / Graphite for PLUG

Below is my presentation from April for the Portland Linux/Unix Group (PLUG) Computer Group Advanced Topics Meeting.  I wish I could thank the second person who jumped in and help answer some of the questions that I didn't have answers to.

There is a Version 1.0 (my draft), as well as a Version 1.1 (what I presented from) LibreOffice Presentation attached.  Please contact me if you have any questions.  I'm hoping to add some more Articles on this website when time allows (when does it ever?).

lowspace.sh

This script is called from a cron job (scheduled task) and emails me on a daily basis this data so I can track disk space usage.  I install it on all my systems (though I should probably do something different, like store the values in a database or something).

Drupal node table information

I don't advocate updating databases without going through the application.  However, I had issues with some data when I migrated it from one database to another and had to fix the data.

This is REALLY not recommended, and your results will vary depending on which version you are using.

This SQL generated the update statement I needed to run to fix the problem.

Tags:

AIDE Presentation

A copy of the quick presentation I did on using AIDE for the local Portland Linux/Unix Group. Presentation was quick and dirty, and in PowerPoint format.

Creating A Drupal Database

The following SQL will create a PostgreSQL database for Drupal.  I'm calling it drupal in this case, but you can call it whatever you want.

CREATE DATABASE drupal
  WITH OWNER = drupalweb
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'en_US.UTF-8'
       LC_CTYPE = 'en_US.UTF-8'
       CONNECTION LIMIT = -1;
GRANT CONNECT, TEMPORARY ON DATABASE drupal TO public;
GRANT ALL ON DATABASE drupal TO drupalweb;

 

Uptime vs Availability

Do we need to sacrifice system uptime against system availability. And I use the term system availability to identify both uptime and unscheduled outages. So here system availability includes time from both unscheduled and scheduled outages. Why would I ask such a thing? Systems crash for all kinds of reasons: failure in the garbage collector to collect objects or collecting the wrong objects. So why do we need to do regular scheduled reboots of the system?

PG Day 2010 Presentation

My slide presentation from PDX PG Day 2010 in Portland, Oregon. The presentation was created in Open Office (the .ODP file - Postgresql (OSCON).odp), but I've also created a PPT version (Postgresql (OSCON).ppt) exported from Open Office.

Finding the UUID for Linux Drives

The Universally Unique Identifier (UUID) is a good way to mount drives under Linux with SATA drives (or any drives, PATA or IDE).  This ensures that when you have more than one harddrive, it always gets mounted to the same location specified in /etc/fstab.  The reason is that SATA drives are mounted when they're found and on one reboot can come up as

Tags:

Pages

Subscribe to Tim's Computer Web Site RSS