On top of what Vivek said, you need to update your pg install. 7.4.2 had a few data eating bugs if I remember correctly. 7.4 branch is up to 7.4.18, and those are a lot of bug fixes (2+ years) you're missing. If one of those bugs eats your data, don't expect any sympathy.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
