| From: | "Paul Ottar Tornes" <critical(at)tiscali(dot)no> |
|---|---|
| To: | "psql" <pgsql-general(at)postgresql(dot)org> |
| Subject: | I cant add a new user to pgSQL.. What is wrong? |
| Date: | 2002-10-31 01:03:28 |
| Message-ID: | 000a01c28079$52df9de0$0400000a@critical |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Sturman | 2002-10-31 02:04:24 | 6.5 data export issues |
| Previous Message | Roj Niyogi | 2002-10-31 00:59:45 | Re: I cant add a new user to pgSQL.. What is wrong? |