From: Jeoffrey L. Palacio <jeoff@ibma.org.ph>
To: pgsql-admin@postgresql.org
Subject: psql: FATAL: user "root" does not exist createdb: database creation failed
Date: Tue, 16 Nov 2004 13:55:30 +0800 (PHT)
Message-ID: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jeoff@ibma.org.ph
Subject: Re: psql: FATAL: user "root" does not exist createdb: database creation failed
In-Reply-To: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201>
References: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox