Re: create database, user - Mailing list pgsql-novice

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