Re: adding a superuser

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-docs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: adding a superuser
Date: 2001-09-17 15:19:06
Message-ID: 200109171519.f8HFJ6In009155@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

"Karl Babcock" wrote:
>I tried that and it says:
>
>psql: Peer authentication failed for user 'postgres'
>createuser: creation of user "root" failed
>
>
>"TeuK" <humpf(at)yahoo(dot)fr> wrote in message
>news:9o2dhq$gc$1(at)front4m(dot)grolier(dot)fr(dot)(dot)(dot)
>> I think user root is not known in Postgres user and that's why you want to
>> add it (;
>>
>> try :
>>
>> createuser -d -a -U postgres root
>>
>> As a rule postgres is running under postgres user account that is a
>> superuser.

It sounds as though you are using a Debian package (peer authentication
is peculiar to the current Debian release and will disappear again
when 7.2 is released). The default authentication in Debian is:

local all peer sameuser

and if that is unchanged, you cannot connect as any user other than your
own Unix login id. You need to run this command as Unix user 'postgres':

# su - postgres
$ createuser -d -a root

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Honour the LORD with thy substance, and with the
firstfruits of all thine increase; So shall thy barns
be filled with plenty, and thy presses shall burst out
with new wine." Proverbs 3:9,10

Browse pgsql-docs by date

  From Date Subject
Next Message Stephan Szabo 2001-09-17 17:20:17 Re: adding a superuser
Previous Message Serge V. Tarasov 2001-09-17 14:34:28 Re: adding a superuser

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2001-09-17 15:27:31 Re: I could do with some guidance
Previous Message Stephan Szabo 2001-09-17 15:18:03 Re: Dropping Fields In A Table