I cant add a new user to pgSQL.. What is wrong?
I get this:
idle:/www/maloyportalen.no$ createuser remi
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
Password:
psql: FATAL 1: Password authentication failed for user "postgres"
createuser: creation of user "remi" failed
I think it might have something to do with pg_hba.conf, so here it is:
local all password
host all 127.0.0.1 255.0.0.0 password
host maloy 62.101.192.200 255.255.255.0 password
host maloy 80.202.101.84 255.255.255.0 password
host all 0.0.0.0 0.0.0.0 reject
Date: Thu, 31 Oct 2002 02:03:28 +0100
From: "Paul Ottar Tornes" <critical@tiscali.no>I get this:
idle:/www/maloyportalen.no$ createuser remi
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
Password:
psql: FATAL 1: Password authentication failed for user "postgres"
I had a similiar problem. In my case it was the password input of the
createuser script that seems to be seriously broken (I had to enter the
password four(!) times until it was accepted).
Log in with psql as postgres and issue a CREATE USER command.
That should work reliably.
Christoph Dalitz
Import Notes
Reply to msg id not found: 20021031005654.EFBA7475FF1@postgresql.orgReference msg id not found: 20021031005654.EFBA7475FF1@postgresql.org | Resolved by subject fallback