Saturday, January 21st, 2012
Here is the start of a query for pulling out travel requirements for conference attendees.
SELECT P.last_name, P.first_name,
CPT.arrival_from,
CPT.arrival_to,
CPT.need_accommodation
FROM conference_person_travel CPT, conference_person CP, conference C, person P
WHERE CPT.need_accommodation
AND CPT.conference_person_id = […]
Posted in General | No Comments »
Sunday, January 8th, 2012
I just bought and downloaded memtestosx.
Last login: Sun Jan 8 16:14:10 on ttys001
[dan@dent:~] $ /Volumes/memtest_422/memtest/memtest ; exit;
Memtest version 4.22 (64-bit)
Copyright (C) 2004 Charles Cazabon
Copyright (C) 2004-2008 Tony Scaminaci (Macintosh port)
Licensed under the GNU General Public License version 2 only
NOTE: No command-line arguments have been specified
Using defaults: Test all available memory, one test […]
Posted in General | No Comments »
Friday, December 30th, 2011
After a very long effort, this is the solution:
CREATE OR REPLACE FUNCTION conflict.conflict_statistics(conference_id integer, OUT conflict_level text, OUT conflicts integer)
RETURNS SETOF record
LANGUAGE plpgsql
AS $function$
#variable_conflict use_variable
DECLARE
conflict TEXT;
conflict_rows INTEGER;
BEGIN
FOR conflict_level IN
SELECT conflict_level.conflict_level FROM […]
Posted in General | 1 Comment »
Thursday, October 6th, 2011
Today I received this rather devious spam. Invoke education, children, libraries, and hope that someone will link to their site. I’m not sure *why* they want this particular site promoted. There’s not much useful information there. No attempt to sell anything. I’m confused.
Perhaps this was legit. But then, […]
Posted in General, Open Source | No Comments »
Monday, June 20th, 2011
As part of my magical Bacula website, I wanted to know when my tape drive required a cleaning tape. It appears that smartctl will reveal this information:
[dan@kraken:/usr/home/dan] $ sudo /usr/local/sbin/in/smartctl -d scsi -x /dev/nsa0
Password:
smartctl 5.39.1 2010-01-28 r3054 [FreeBSD 8.2-STABLE amd64] (local build)
Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net
Device: DEC […]
Posted in General | 1 Comment »
Friday, May 27th, 2011
I have been using Bacula since 2004. I started off on DDS tapes, then moved to DLT. Now I’m backing up to a ZFS array and the copying to tape.
About a year ago, I obtained about 200 DLT tapes from a friend. They were no longer used at his place of work. […]
Posted in General | No Comments »
Sunday, May 15th, 2011
Bacula is a backup and restore solution which I’ve been using and contributing to since 2004. Recently, I started backing up to disk and then copying to tape later. This approach, combined with a scratch pool, has proven to be very low maintenance, from a sysadmin point of view. I think all […]
Posted in General | No Comments »
Wednesday, April 6th, 2011
I hate it when this happens:
[root@kraken /usr/home/dan]# /usr/local/sbin/mtx-changer /dev/pass10 list
mtx: Request Sense: Long Report=yes
mtx: Request Sense: Valid Residual=no
mtx: Request Sense: Error Code=0 (Unknown?!)
mtx: Request Sense: Sense Key=No Sense
mtx: Request Sense: FileMark=no
mtx: Request Sense: EOM=no
mtx: Request Sense: ILI=no
mtx: Request Sense: Additional Sense Code = 00
mtx: Request Sense: Additional Sense Qualifier = 00
mtx: Request Sense: BPV=no
mtx: Request […]
Posted in General | 2 Comments »
Wednesday, March 9th, 2011
This looks interesting for an SSD. A co-worker was saying: SandForce is the way to go.
Posted in General | No Comments »
Sunday, March 6th, 2011
Links within events in Pentabarf are done like this:
[text](http://example.org/)
Posted in General, Open Source, Pentabarf, PostgreSQL | No Comments »