NOTE TO SELF
Name based virtual hosts are quite possible with SSL if you use SNI. A fairly recent version of OpenSSL is required for that, >= 0.9.8.
PGCon 2011 – schedule delayed
On Saturday, I tweeted that the schedule for PGCon 2011 would be released. I was wrong. We are having a hard time choosing from amongst all the talks we have received. Choice is a fine problem to have, but we apologize for the delay. All submitters have been emailed about this delay. The Call For
PGCon 2011 – schedule delayed Read More »
Copying to tape, missed something….
I recently wrote about copying jobs with a very good backup tool. My goal was to keep copies of the backups on both disk and tape. Since then, I started playing around with a little webpage to keep tabs on what’s in my tape libary. Today I noticed a little problem. I have backups from 75 days ago that are waiting to be copied to tape.
I’ll just let you think about why this happened. Yesterday, this queue held jobs that were about 16 hours old. How did this old job get into the queue?
Copying to tape, missed something…. Read More »
Carved in stone
This was said by me on IRC today: You say ‘ignoring a large user base’ as if there is something wrong with that. PostgreSQL has a long history of not catering to the masses. This is what makes it such a great tool. Only well thought out and well conceived features go into PostgreSQL. And
Oh damn! I should have used screen!
I’m sure you’ve had one of these moments: ssh to a server start a long running command wanted to disconnect and go home Oh Damn! I should have used screen! I have long wanted such a tool Now there appears to be a solution. reptyr seems to fit the bill. That URL also describes a
Oh damn! I should have used screen! Read More »
How to to respond to valid criticism
This email came to my attention this evening (be sure to read the bottom half of the post). In the original post, Joe Barbish asks for a committer to commit his patch and asks for feedback. Eygene Ryabinkin provides some feedback. All I can say is: when you ask for advice, and get it, don’t
How to to respond to valid criticism Read More »
Bacula – certificates expired
The new year started off poorly for my backups, and it is all my fault. Each of my remote servers is backed up utilizing Bacula’s TLS (Transport Layer Security) features. This requires an X.509 certificate which I obtain via CACert. These certificates have expired: 01-Jan 02:00 bacula-dir JobId 44464: Start Backup JobId 44464, Job=nyi_maildir.2011-01-01_02.00.00_07 01-Jan
Bacula – certificates expired Read More »
zfs destroy
Here I go, removing an old ZFS dataset that is no longer required. But first, some stats (which have been edited to remove non-zfs output): [dan@kraken:~] $ df -h Filesystem Size Used Avail Capacity Mounted on storage 1.4T 15G 1.4T 1% /storage storage/bacula.DO.NOT.USE 5.8T 4.4T 1.4T 76% /storage/bacula.DO.NOT.USE storage/compressed 1.4T 49K 1.4T 0% /storage/compressed storage/compressed/bacula
How much are those volumes in the library? (redone)
I have an improvement on the original query. This one outputs ‘nil’ if the volume is empty. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, CASE WHEN volbytes < = 64512 THEN 'nil' else pg_size_pretty(volbytes) END FROM media, pool WHERE media.poolid = pool.poolid AND volumename LIKE 'ETU0%' AND inchanger != 0 ORDER BY slot; mediaid
How much are those volumes in the library? (redone) Read More »
No scroll lock? use FN-C
Some of the newer keyboards do not have a scroll lock key. Try FN-C instead. Does that work for you?
No scroll lock? use FN-C Read More »