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