pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql: FATAL:  user "root" does not exist  createdb: database creation failed
3+ messages / 3 participants
[nested] [flat]

* psql: FATAL:  user "root" does not exist  createdb: database creation failed
@ 2004-11-16 05:55 Jeoffrey L. Palacio <jeoff@ibma.org.ph>
  2004-11-16 20:17 ` Re: psql: FATAL:  user "root" does not exist  createdb: Christian Fowler <spider@viovio.com>
  2004-11-17 13:53 ` Re: psql: FATAL: user "root" does not exist createdb: database creation failed Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Jeoffrey L. Palacio @ 2004-11-16 05:55 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: psql: FATAL:  user "root" does not exist  createdb:
  2004-11-16 05:55 psql: FATAL:  user "root" does not exist  createdb: database creation failed Jeoffrey L. Palacio <jeoff@ibma.org.ph>
@ 2004-11-16 20:17 ` Christian Fowler <spider@viovio.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Christian Fowler @ 2004-11-16 20:17 UTC (permalink / raw)
  To: Jeoffrey L. Palacio <jeoff@ibma.org.ph>; +Cc: pgsql-admin


execute these as the postgres user:

su - postgres

One option is to create a super-user with something like:

postgres$ createuser -d -a -P jeoff

then:

jeoff$ createdb ibmadb

then do administrative things with that user. I would advise *NOT* using 
root. If this is a tightly controlled (non-shared) machine, you could make 
a super user as your normal unix login (which hopefull is not root). 
Ideally you'll only need root to start the postgres service.



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

[ \ /
[ >X<   Christian Fowler      | spider AT viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: psql: FATAL: user "root" does not exist createdb: database creation failed
  2004-11-16 05:55 psql: FATAL:  user "root" does not exist  createdb: database creation failed Jeoffrey L. Palacio <jeoff@ibma.org.ph>
@ 2004-11-17 13:53 ` Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Vishal Kashyap @ [SaiHertz] @ 2004-11-17 13:53 UTC (permalink / raw)
  To: Jeoffrey L. Palacio <jeoff@ibma.org.ph>; +Cc: pgsql-admin

Try this 

createdb -U postgres  ibmadb


On Tue, 16 Nov 2004 13:55:30 +0800 (PHT), Jeoffrey L. Palacio
<jeoff@ibma.org.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@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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-11-17 13:53 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-16 05:55 psql: FATAL:  user "root" does not exist  createdb: database creation failed Jeoffrey L. Palacio <jeoff@ibma.org.ph>
2004-11-16 20:17 ` Re: psql: FATAL:  user "root" does not exist  createdb: Christian Fowler <spider@viovio.com>
2004-11-17 13:53 ` Re: psql: FATAL: user "root" does not exist createdb: database creation failed Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>

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