On Friday 30 January 2004 10:23 am, Jerome Lyles wrote:
On Friday 30 January 2004 01:37 am, Paul Thomas wrote:
On 30/01/2004 09:39 Susemail wrote:
[snip] In any case I don't have a pg_hba.conf file:
You should have, unless you haven't done an initdb...
True, I hadn't done an initdb:
Still not able to authenticate:
FATAL: IDENT authentication failed for user "adriel" FATAL: IDENT authentication failed for user "postgres"
The problem turned out to be two copies of pg_hba. One in "/usr/local/pgsql/data/pg_hba.conf" the other in "/var/lib/pgsql/data/pg_hba.conf" "/var/lib/pgsql/data/pg_hba.conf" is in the Root Directory of postgres on my system so that's the one the system was using. I thought the system was using the other one: "/usr/local/pgsql/data/pg_hba.conf", the only one I knew about. Thank you for helping me figure it out, Jerome