| From: | Matthew Stanfield <matthew(at)propertyknowledge(dot)com> |
|---|---|
| To: | PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | No pg_hba.conf entry error. |
| Date: | 2002-04-08 13:37:51 |
| Message-ID: | 3CB19D2F.CF7DA2C8@propertyknowledge.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
When I try to create a new user for postgres like this:
su -c 'createuser -d -a mattstan' postgres
[NOTE: This worked yesterday and user mattstan does not already exist.]
I get this error:
psql: FATAL 1: No pg_hba.conf entry for host localhost, user postgres,
database template 1.
createuser: creation of user mattstan failed.
But my pg_hba.conf has just these lines not commented out:
local all trust
host all 127.0.0.1 255.255.255.255 trust
The only thing I can see that may be the problem is the ownership of the
pg_hba.conf file.
When I 'ls -l' all the files say:
... ... postgres postgres size date filename
but the pg_hba.conf file says:
... ... postgres root size date pg_hba.conf
But I don't know how to change this.
Thanks and regards,
..matthew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tony | 2002-04-08 13:42:35 | Re: I18n & Pgaccess ( & psql) |
| Previous Message | Jan Wieck | 2002-04-08 13:22:09 | Re: retun cursor |