Skip site navigation (1) Skip section navigation (2)

psql: FATAL: user "root" does not exist createdb: database creation failed

From: "Jeoffrey L(dot) Palacio" <jeoff(at)ibma(dot)org(dot)ph>
To: pgsql-admin(at)postgresql(dot)org
Subject: psql: FATAL: user "root" does not exist createdb: database creation failed
Date: 2004-11-16 05:55:30
Message-ID: 36771.61.9.47.201.1100584530.squirrel@61.9.47.201 (view raw or flat)
Thread:
Lists: 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(at)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(at)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

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2004-11-16 07:18:53
Subject: Re: evil characters #bfef cause dump failure
Previous:From: matthiasDate: 2004-11-16 02:21:06
Subject: how to handle larger databases?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group