CODEWITHSUNDEEP
postgresqlubuntu
Pramod Edathil
Pramod Edathil

Reputation: 17

bash: etc/postgresql/8.4/main/pg_hba.conf: No such file or directory

i159@i159-desktop:~$ psql -U geouser -W -d deodb
Password for user geouser: 
psql: FATAL:  password authentication failed for user "geouser"
FATAL:  password authentication failed for user "geouser"

After this I checked in /etc/postgresql/8.4/main/pg_hba.conf.

When am executing the above command am getting this error:

bash: etc/postgresql/8.4/main/pg_hba.conf: No such file or directory

How can I fix this?

Upvotes: 1

Views: 1732

Answers (1)

Pavel Stehule
Pavel Stehule

Reputation: 45795

PostgreSQL doesn't start without this file - so pg_hba.conf should exist on your server.

This file is usually in data directory - you can try

sudo su postgres
psql postgres -c "show hba_file"

Upvotes: 1

Related Questions