psql: FATAL:missing or erroneous pg_hba.conf file

Tue, Nov 24, 2009

I installed postgres sql and when I tried to login with user that I created using command line with password I got below error:

psql: FATAL: missing or erroneous pg_hba.conf file

HINT: See server log for details.

This error describes that there is an error encountered in postgres sql configuration file.

Here is what we did to fix it.

Open pg_hba.conf file using your favourite editor and make below entry:

local all all trust trust
host all all 127.0.0.1/32 password

Rating: 0.0/10 (0 votes cast)

Rating: 0 (from 0 votes)

2 Responses to “psql: FATAL:missing or erroneous pg_hba.conf file”

Alpesh says:

You need to write as follow pg_hba.conf

local all all trust

just one time write trust instead of two time as U have done mistake in pg_hba.conf file.

Rating: 0.0/5 (0 votes cast)

Rating: 0 (from 0 votes)

ravi.ranjan says:

Hi Alpesh,

Thanks for the correction.

Rating: 0.0/5 (0 votes cast)

Rating: 0 (from 0 votes)

Solution Expert Online Blogs