Re: I cant add a new user to pgSQL.. What is wrong?

Paul,

change the first line in the pg_hba.conf file from password to trust

Then, run createuser

You might also want to give postgres a password with the command: ALTER USER postgres WITH PASSWORD 'blahblahblah';

Then you can change it back from trust to password in the pg_hba.conf file.

-roj
niyogi@pghoster.com

Paul Ottar Tornes wrote:

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