pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christian Fowler <spider@viovio.com>
To: Jeoffrey L. Palacio <jeoff@ibma.org.ph>
Cc: pgsql-admin@postgresql.org
Subject: Re: psql: FATAL:  user "root" does not exist  createdb:
Date: Tue, 16 Nov 2004 15:17:02 -0500 (EST)
Message-ID: <Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com> (raw)
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>


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



view thread (3+ messages)  latest in thread

Message-ID: <Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com>
Permalink:  ../Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com

 · 

reply

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: spider@viovio.com, jeoff@ibma.org.ph
  Subject: Re: psql: FATAL:  user "root" does not exist  createdb:
  In-Reply-To: <Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com>
  References: <36771.61.9.47.201.1100584530.squirrel@61.9.47.201> <Pine.LNX.4.61.0411161507270.5614@leda.steelsun.com>

* 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