No pg_hba.conf entry error.

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

Browse pgsql-general by date

  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