I never have used PostgreSQL. If it's anything like MySQL, there is a table used to hold privilages for accounts. You could edit it through cmd/ssh or with a web based interface, such as PHPMyAdmin. I really don't know though. Try google'ing it.
Thanks alot NerdN -- love your sig!!! How 1337 are you
ok I tried googleing -- but to no avail. I will try something with CMD because it is running on my machine. We have something called phpPGAdmin (equiv of myadmin) but I don't know how to alter database apsswords in it -- ill look in their docs....
If you or anyoine else have anymore words of wisdom let me know -- I am subscribed to the thread!