LANG prevents PostgreSQL initdb

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

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 »

OneCMDB – notes for improvment

These are my notes on attempting to setup OneCMBD. Some of these items would be added directly to their wiki, if I they give me access. At http://www.onecmdb.org/wiki/index.php/Get_Started_V2.0#On_Linux_platforms_2: bin/onemdb.sh start should be bin/onecmdb.sh start (missing a ‘c’) Same for the stop command. Same error occurs in the README. bin/onecmdb.sh contains #!/bin/bash. Why bash? Why not /bin/sh? ELF binary type “0” not known – you need to load linux compatibility: kldload linux. This needs

OneCMDB – notes for improvment Read More »

Incorrect bind column causes HY093

Over the past few weeks, I’ve been learning more about XSL, Javascript, and CSS. Along the way, I’ve been doing much more work with PDO. Yesterday I encountered a 501: Internal Server Error which had me stumped until this morning. The SQL was something like this: INSERT INTO mybconfig.keys (key_name, key_type_id) VALUES ( :key_name, :key_id_type )’ Upon calling execute(), the exception thrown was similar to this: 501: Internal Server Error Description: The server

Incorrect bind column causes HY093 Read More »

PGCon 2009 Schedule released

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 »

Scroll to Top