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: | Raw Message | Whole Thread | 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 |