Submitted by TimBruce on Wed, 01/17/2007 - 17:40
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 FlightStats.com), although you will find occasional articles related to Microsoft Windows.
The purpose of this web site is two-fold:
Submitted by TimBruce on Sat, 04/01/2006 - 16:49
I am a Database Administrator for FlightStats.com. I work mostly with the PostgreSQL database engine although I'm looking at both MongoDB and Hadoop. I also do a limited amount of systems administration with Solaris and Linux - specifically Ubuntu.
While I mainly use PostgreSQL at work, my background includes Sybase, SQL Server, PostgreSQL and MySQL and I use both MySQL and PostgreSQL at home.
Submitted by TimBruce on Thu, 02/24/2011 - 20:08
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).
Submitted by TimBruce on Thu, 02/24/2011 - 19:31
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.
Submitted by TimBruce on Tue, 09/21/2010 - 20:53
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.
Submitted by TimBruce on Fri, 09/10/2010 - 12:41
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;
Submitted by TimBruce on Wed, 09/08/2010 - 05:37
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?
Submitted by TimBruce on Sun, 07/18/2010 - 09:32
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.
Submitted by TimBruce on Tue, 06/22/2010 - 22:26
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
Submitted by TimBruce on Fri, 04/16/2010 - 19:38
I just completed a presentation for my local PostgreSQL User Group (the Portland PUG) and gave it last Thursday. I need to add some updates to clarify things and round out some of it, but here it is as I gave it.
Hopefully there are others who will find it useful.
As a side note, there are NOTES on some of the slides to go along with the material being presented.
Pages
