pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pedro Almeida <niker@netvisao.pt>
To: pgsql-admin@postgresql.org
Subject: pgsql initial superuser
Date: Mon, 16 Feb 2004 17:24:15 +0000
Message-ID: <4030FCBF.2020005@netvisao.pt> (raw)

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




view thread (6+ messages)  latest in thread

Message-ID: <4030FCBF.2020005@netvisao.pt>
Permalink:  ../4030FCBF.2020005@netvisao.pt/
Also on:    postgresql.org/message-id/4030FCBF.2020005@netvisao.pt

 · 

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: niker@netvisao.pt
  Subject: Re: pgsql initial superuser
  In-Reply-To: <4030FCBF.2020005@netvisao.pt>
  References: <4030FCBF.2020005@netvisao.pt>

* 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