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(at)pghoster(dot)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