-Hello
- I am trying to use postgresql because Access doesn't provide ANSI SQL compliant, or user lockings, mysql doesn't support foreign keys, triggers, user lockings, user views.

- I want to createuser to create a testDB but when I create a test user I keep getting this error message

$ createuser dannyh
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
psql: FATAL 1: SetUserId: user 'dannyh' is not in 'pg_shadow'
createuser: creation of user "dannyh" failed
$


Question

1) What is the problem? how do I fix this problem?

Looking forwrd to your feedback.

dannyh

dannyh@idx.com.au