Postgres Pro
Downloads
Home   >   mailing lists

I cant add a new user to pgSQL.. What is wrong? - Mailing list pgsql-general

From Paul Ottar Tornes
Subject I cant add a new user to pgSQL.. What is wrong?
Date
Msg-id 000a01c28079$52df9de0$0400000a@critical
Whole thread Raw
Responses Re: I cant add a new user to pgSQL.. What is wrong?  (Roj Niyogi <niyogi@pghoster.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Patrick Bakker
Date:
Subject: Questions on specifying table relationships
Next
From: Roj Niyogi
Date:
Subject: Re: I cant add a new user to pgSQL.. What is wrong?