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 from 5K (globals.sql) to 2.8G (freshports.sql). The script that does this is pretty simple, but has evolved over […]
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 upgrade path from Openads-PgSQL-2.0.11-pr1, the latest releast of OpenAds to use PostgreSQL, to OpenX 2.6. The first problem
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 -n’) 2008.10.17 02:46:02 LOG6[43534:134656000]: poll() used – no FD_SETSIZE limit for file descriptors 2008.10.17 02:46:02 LOG5[43534:134656000]: 5417 clients
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. I don’t want to ssh to 10 different systems just to update a script on each one. I
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 of how it works, and illustrate why Bacula is becoming so widespread. My talk was scheduled for the
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 it is much more complex to set up. OpenVPN is pretty simple. At present, my wireless gateway is
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 »