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

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

From: "Vishal Kashyap (at) [SaiHertz]" <vishalonlist(at)gmail(dot)com>
To: "Jeoffrey L(dot) Palacio" <jeoff(at)ibma(dot)org(dot)ph>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql: FATAL: user "root" does not exist createdb: database creation failed
Date: 2004-11-17 13:53:58
Message-ID: 77b69d210411170553319b260f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Try this 

createdb -U postgres  ibmadb


On Tue, 16 Nov 2004 13:55:30 +0800 (PHT), Jeoffrey L. Palacio
<jeoff(at)ibma(dot)org(dot)ph> wrote:
> 
> 
>  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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly
> 


-- 
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com,
http://vishalkashyap.tk

In response to

pgsql-admin by date

Next:From: Fred WohlfertDate: 2004-11-17 16:43:05
Subject: error loading data with copy
Previous:From: ogjunk-pgjedanDate: 2004-11-17 13:22:51
Subject: Re: 7.3.4 -> 7.3.8 - a little stuck

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