With all the databases I run, I need a daily sanity check. I download a copy of each database and do a test load on my system at home. Today I timed that process: $ time ~/bin/backup-supernews.sh … real 77m57.323s user 12m52.610s sys 0m56.136s There are 11 such databases. The dump files range in size […]
Database load times Read More »
I’ve been running ads on my websites since early 1999, so nearly 10 years. It was roughly May 2002 that I started using phpPgAds. This was the PostgreSQL version of phpAdsNew. This project became OpenAds and is now known as OpenX. Recently I decided to upgrade to the latest version of OpenX. There was a
openx upgrade issues Read More »
Tonight I encountered this problem when starting stunnel: 2008.10.17 02:46:02 LOG7[43534:134656000]: Private key loaded 2008.10.17 02:46:02 LOG7[43534:134656000]: SSL context initialized for service 6000 2008.10.17 02:46:02 LOG5[43534:134656000]: stunnel 4.25 on i386-portbld-freebsd6.3 with OpenSSL 0.9.7e-p1 25 Oct 2004 2008.10.17 02:46:02 LOG5[43534:134656000]: Threading:PTHREAD SSL:ENGINE Sockets:POLL,IPv6 Auth:LIBWRAP 2008.10.17 02:46:02 LOG6[43534:134656000]: file ulimit = 11095 (can be changed with ‘ulimit
stunnel “local socket: Protocol not supported” Read More »
In a sea of inadequete cfengine examples, one stands out: http://www.sysadmin.hep.ac.uk/wiki/Cfengine. I’m in the early stages of developing an administration strategy for a jail server I’m setting up. It will run regression tests for Bacula. I’ve already found ezjail, which will help me create the jails. What I needed was tool for administering the jails.
cfengine – practical examples Read More »
A very key point in this article. Product vs project. Read: http://people.planetpostgresql.org/greg/index.php?/archives/120-Postgres-is-not-for-sale.html
MySQL bought. PostgreSQL not for sale. Read More »
I was at OSCON 2007 this week. I was there to present my Nobody Ever Regretted Making a Backup talk: In the past few years, Bacula has been gaining ground on more established solutions, both open source and proprietary. This talk will introduce you to Bacula, show you the main components, give you an outline
OSCON 2007 – the details, the people Read More »
I’ve been playing with OpenVPN since mid December. I like it. I like it better than IPsec. Why? Because OpenVPN can give me direct access to all my systems wherever I am. I can cvsup from my cvsup server at home from a hotel in Toledo (if I’m ever there). IPsec can do that. But
Good bye IPsec. Hello OpenVPN. Read More »
Ever had a cactus remotely injected? Sounds painful. Not really.
cacti – remove injection exploit Read More »
More and more people are learning about Bacula. Here is a little survey I did at LISA06.
Bacula – Network Backups Read More »
There will be a PostgreSQL Conference in May 2007. I’ll definintely be there! I’m looking forward to this. It’s right after a BSD conference. There will be quite a few people attending both conferences. One trip, two conferences, a great time.
The PostgreSQL Conference Read More »