I just installed PostgreSQL 6.5.2 on my PC (Linux-Mandrake 6.1) and
everything seemed to be going fine until I got to the step where I
create the initial test DB (step 20 of Ch. 5 of the administrator's
guide).
I get:
> creatdb
Connection to Database 'template1' failed.
Missing or mis-configured pg_hba.conf file
createdb: database creation failed on fxhrt.
Now my pg_hba.conf file is in /usr/local/pgsql/data where it belongs.
PGDATA points to this directory. The pg_hba.conf file is readable by
the DBA account.
the file is configured like:
local trust
host all 127.0.0.1 255.255.255.255
trust
I believe this is wide open so I shouldn't be having access violations.
So why am I getting this error?
Thanks,
Hal Tippens
************