postgresql configuration and set-up

[Tom Allison <tallison@tacocat.net>]

I'm trying to get debian's postgresql server running on a machine.

But I'm stuck on what the passwords are for the users I create.

createdb foo
createuser foouser

works just fine.
But how do I log in to the database foo as user foouser?
It says I need a password in the docs,  But I have no clue what it might 
be, I was never asked for one.