Open Source

LANG prevents PostgreSQL initdb

2 Comments / Open Source, PostgreSQL / By /

I was looking at RackMonkey and RackTables today. As part of the latter, I was installing PostgreSQL on my FreeBSD workstation. I failed. This had worked many times before, on many other servers. This was the first time I’d seen this particular situation. # /usr/local/etc/rc.d/postgresql initdb The files belonging to this database system will be owned by user “pgsql”. This user must also own the server process. The database cluster will be initialized […]

LANG prevents PostgreSQL initdb Read More »

qemu – running emulation

Leave a Comment / Open Source / By /

I managed to get CENTOS5 booting today. In a virtual machine on my FreeBSD workstation. This post is mainly just notes for myself. Create the blank HDD image file on my host OS: qemu-img create -f qcow2 c.img 3G Installing the new guest OS, by booting from the ISO image which appears as a CDROM: qemu -cdrom CentOS-5.2-i386-bin-DVD.iso.iso -hda c.img -m 256 -boot d Setting up the bridging between the guest and the

qemu – running emulation Read More »

PGCon 2009 Schedule released

Leave a Comment / Conferences, PGCon, PostgreSQL / By / /

The preliminary PGCon 2009 schedule has been released. PGCon is the premiere PostgreSQL conference. It is simply the best place to meet other PostgreSQL people and learn more. The talks are absolutely amazing, not to mention the great social atmosphere. If you’re looking to hire any PostgreSQL talent, PGCon is the place to be. You’ll find more PostgreSQL people (DBAs, coders, web developers, core contributers) than at any other conference. If you’re looking

PGCon 2009 Schedule released Read More »

Moving my PGP from Windows to KDE

Leave a Comment / Open Source / By /

I found my old PGP key today. I haven’t used it in quite some time. But there it was, on my Windows machine: secring.skr I use Thunderbird on FreeBSD, under KDE. I see I need to install mail/enigmail if I want to use PGP (well, the GnuPG implementation of PGP). This appears to be my slippery slope. First, I encountered this: [dan@laptop:/usr/ports/mail/enigmail] $ sudo make install clean Password: => enigmail-0.93.0.tar.gz doesn’t seem to

Moving my PGP from Windows to KDE Read More »

Migrating one Bacula Volume to another

Leave a Comment / Backups, Bacula, Open Source / By /

I run Bacula. I have coded for Bacula. Now I’m writing about Bacula again. Bacula is by far and away the best open source program for managing network-based backups. In this article, I will show you how I migrated a bunch of jobs from a disk Volume to a tape Volume. However, the approach I will use can be applied to any type of job migration. Why bother? I’m running of disk space

Migrating one Bacula Volume to another Read More »

Avoiding dynamic IP address woes with a VPN

8 Comments / DNS, Networks, Open Source, OpenVPN / By /

I’m sick of dealing with dynamic IP issues. My broadband connection at home has a dynamic IP address. I can always find out what my home IP address is. I’m using dns/noip to manage a hostname which points to home. I can always ssh home via the hostname. The problems arise when I try to restrict access to services provided at home or access to services on external servers. For example, the web

Avoiding dynamic IP address woes with a VPN Read More »

SVN commits now available

Leave a Comment / FreeBSD, FreshPorts, Open Source / By /

The SVN commits are now available for viewing. At present, only the FreeBSD src tree is working through SVN. Therefore, the easiest way for you to see those commits is through the FreshSource interface. That link takes you to the SVN version. You will notice that the src commits are duplicated. This was not done intentionally. However, it is fortunate in it allows for easy fact checking. This error is possible only because

SVN commits now available Read More »

Database load times

Leave a Comment / FreeBSD, Open Source, PostgreSQL / By /

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 »

openx upgrade issues

1 Comment / Open Source, PostgreSQL / By /

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 »

Scroll to Top