Category: PostgreSQL Help
User name problems --help
-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