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

pgsql initial superuser

From: Pedro Almeida <niker(at)netvisao(dot)pt>
To: pgsql-admin(at)postgresql(dot)org
Subject: pgsql initial superuser
Date: 2004-02-16 17:24:15
Message-ID: 4030FCBF.2020005@netvisao.pt (view raw or flat)
Thread:
Lists: pgsql-admin
Hello. this is my "first" time using pgsql, and I seem to be running to 
a bit of a corner here :-)

I've understood how to add a superuser/database-user/user but I have no 
user to begin with.

~# createuser superuser
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) y
psql: FATAL:  user "root" does not exist
createuser: creation of user "superuser" failed

So I need someway to add a user so I can add others. I belive this is 
done in the pg_hba.conf file, but so far I've been unlucky. I'm using 
the debian distributed pg_hba.conf file set up for local access, and I 
tried the following lines, each a complete failure:

pg_hba.conf
<snip>
local all root md5
#OR
#local all root ident
<snip>

Even with "createuser blabla -Uroot -W" and using the "ident" auth 
method fails. What am I missing here?

Thank you for the support :-D


Responses

pgsql-admin by date

Next:From: Greg PatnudeDate: 2004-02-16 17:56:49
Subject: Re: Urgent!!!! Setting permissions on Views
Previous:From: Chris GamacheDate: 2004-02-16 16:42:23
Subject: Re: Upgrading 7.2.4 to 7.4.1

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