(Haven't see Malte's Knoppix CD yet...)
You can write to a ram disk. I guess that's what PostgreSQL is doing there. You can install your Knoppix boot system to your harddrive, however that because Knoppix still is a mixture of Debian and RedHat it is usually not recommended.