Monthly Archives: June 2006

France Brazil

France Brazil tonight is going to be huge here in Bondi with the huge brazilian colony. With the small 23 Beach Road going to be full of french at 5h oclock Sunday morning.

Malaria

Every year i am affected by a Malaria crisis i get exactly what is described on Wikipedia:

Symptoms of malaria include fever, shivering, arthralgia (joint pain), vomiting, anaemia caused by haemolysis, haemoglobinuria, and convulsions. There may be the feeling of tingling in the skin, particularly with malaria caused by P. falciparum. Consequences of infection with malaria include coma and death if untreated—young children and pregnant women are especially vulnerable. Splenomegaly (enlarged spleen), severe headache, cerebral ischemia and hemoglobinuria with renal failure may occur.

I think I got this when I was traveling in 2002 around Mexico in the region of Chiapas which is supposed to be a high risk region for Malaria (cf: here). And I remember that my first crisis was in La Havana in Cuba staying in the bed sick with diarrhea and fever for a week.

I don’t think there is any medicines against that, it’s basically for me every time the same and it’s not that bad as described by Wikipedia article.

Like this Thursday, I was at work pretty normal and by 14h I had a pretty big head each and could not look at my computer screen anymore. I left work and tried to come back by buses but during my bus ride I was feeling worse and worse and had to go at the first stop to take a taxi (it’s a long way from Leichardht to Bondi Beach). I just crash on the bed get crazy fever cold and warm all the day and night long. Until the day after I feel fine and ok.

Anyway stuff are getting ok now and I can move and type on a computer. And since a lot of people are dying from Malaria I am not so much unlucky to have only a couple of days fever each year.

Get size of Postgres DB from filesystem

Get the size accurately from postgres local filesystem, i guess there is some sql stuff that can do that but that does the job as well for me :

#!/bin/bash
/usr/lib/postgresql/8.1/bin/oid2name  -U postgres|while read -a e;do
name=${e[1]}
oid=${e[0]}
[[ $oid == "All" || $oid == "Oid" || -z $oid || -z $name ]] && continue
typeset -a size
size=(`du -s /var/lib/postgresql/8.1/main/base/$oid`)
size=${size[0]}
printf "%-20s %-20s\n" ${name} ${size}
done | sort -n -r -k 2 |awk '{printf "%-20s%20d Mb\n", $1, $2 / 1024}'