Error Connecting to database

[manoj reddy]

Error Connecting to database FATAL : no pg_hba.conf entry for host"x.x.x.x", user"jiradbuser", database"jiradb", SSL off

i am getting this error. Can anyone suggest what to do?

[jira guy]

Error message is clear. You need to add the host entry in pg_hba file. You need access to your postgres file system to add this entry. Make sure to restart the db.

[manoj reddy g]

Hello,

DB is hosted on AWS Cloud. can you tell the process how to get this pg_hbs.conf file. Have been searching for this since a week

[manoj reddy g]

I know it is available in Clusters data directory but don't know what is the path

[jira guy]

It depends on how your db is configured. Whether it's a managed db or postgres installed on the host?

Found this article related to aws. https://forums.aws.amazon.com/thread.jspa?threadID=143677

If it's a managed db, you just need to make sure they can talk to each other. You wouldn't be able to access the filesystem. 

If the postgres is installed on a host, the file is usually available in /var/lib/postgres/9.6 or run the following command on postgres

SHOW hba_file;

to find the location