September 14th, 2000, 01:46 AM
Join Date: Aug 2000
Time spent in forums: < 1 sec
Reputation Power: 0
- 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
1) What is the problem? how do I fix this problem?
Looking forwrd to your feedback.