Centos 5.x AMI creation

May 20th, 2011

Centos 5.x ami creation: http://bodgitandscarper.co.uk/category/amazon-ec2/

convert postgresql SQL_ASCII to UTF8

April 16th, 2010

Convert Postgresql SQL_ASCII to UTF8 in one step!!!

time pg_dump -i DATABASE_NAME | recode ISO-8859-1..UTF-8 | sed -e “s/SQL_ASCII/UTF8/g” | gzip > DATABASE_NAME.sql.gz

CentOS tip: add sbin directories to your path if member of wheel

March 10th, 2010

Change this:

# Path manipulation
if [ "$""""""EUID" " " " " " " = "0" ]; then

To this:

# Path manipulation
if [ "$""""""EUID" " " " " " " = "0" -o "id -G | sed -e 's/ /\n/g' | grep 10" = "10" ]; then

Wordpress keeps eating backticks and adding quotes. I should fix that later…

heh, turns out pg4wp is eating backticks… wish he’d release 1.2.0…