psql: FATAL: user "root" does not exist createdb: database creation failed - Mailing list pgsql-admin

 Hi to all I'm Jeoffrey, and I'm a newbie to postgreSQL. My problem is
that when i execute the command createdb <database name> i always get a

[root@webdata root]# createdb ibmadb
psql: FATAL:  user "root" does not exist
createdb: database creation failed

Then I tried to create the user root by the command:

createuser <username> and i always get this message also:

[root@webdata root]# createuser
Enter name of user to add: root
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) n
psql: FATAL:  user "root" does not exist
createuser: creation of user "root" failed


my postgresql version is 7.3.4 and my OS is FEDORA CORE 1 x86_64 bit
architecture.

What is wrong about it? please help.


Thanks,

Jeoffrey