How to uninstall postgresql on my Mac (running Snow Leopard)

Question

Upgraded 10.6 from 10.5 and now postgres 8.1 is whacked. To make things worse I tried installing 8.4 which I'm pretty sure just made things ten times worse. Anyhow, the exception I'm getting when I try to fire postgres up and just createuser is this:

createuser: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

HOW do I fully get rid of postgres on my Mac so I can do a do-over?

Thanks

Answer 1

The problem was with the postgres account sitting on my machine.

SO ... removed the account and proceeded doing the uninstall via the instructions here:

http://forums.enterprisedb.com/posts/list/1437.page (see Sachin_S post)