Thorsten,
> The other problem is a password though. I changed one line in your
> example to:
> CREATE USER junk_user encrypted password 'secret';
> And it fails:
> ERROR: parser: parse error at or near "encrypted"
> What's wrong here?
You're probably using PostgreSQL 7.1, or you compiled PostgreSQL 7.2
without current encryption libraries installed on your machine.
-Josh