Urgent: FATAL:  no pg_hba.conf entry for host

Googled it and noticed that we should update somethings in pg_hba.conf however i have been struggling to locate it in my terminal.

 

Can someone help me out on this.

 

Thanks loads,

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi. You will need to contact your server administrator for this as it’s a server configuration issue. SQLPro will be unable to connect until your config file has been updated appropriately.

    Like
      • Jane Zhang
      • Jane_Zhang
      • 3 mths ago
      • Reported - view

      Kyle Hankinson Hi Kyle,

      Thanks for this!

      By server administrator, did you mean the individual who set up the database, i.e: the host.

      Also, is the config file not able to be updated by the methods suggested on stockoverflow such as looking for the pg_hba.conf file and edit it accordingly. Or the only antidote would be to contact the server administrator?

      Thanks,

      Jane

      Like
    • Jane Zhang hi. Are you using a hosted database service such as amazon rds, digital ocean, or other? If so they probably have some sort of ‘firewall’ option that you can add your up address too, or you might need to ssh into the server itself to edit the conf file. If it is a hosted service, you additionally can contact their support and ask how to edit that file.

      Like
      • Jane Zhang
      • Jane_Zhang
      • 3 mths ago
      • Reported - view

      Kyle Hankinson thanks so much for following up. The hosted database is from a 3rd party company so not amazon rds or digital ocean. So in this case, the only way to go around this is to contact them and get them to edit the pg_hba.conf file? unless we could ssh into the server ourselves, in which case I'd like to know how.

      Cheers,

      Jane

      Like
    • Jane Zhang there are many articles available online on how to edit the config file. One such is at https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-postgresql/configure-postgresql-accept-connections.htm. Honestly your best bet is to simply google ‘how to edit pg_hba.conf’ as they will explain it better than I can.

      Like
      • Jane Zhang
      • Jane_Zhang
      • 3 mths ago
      • Reported - view

      Kyle Hankinson thanks again Kyle. I did try out some solutions on Google such as locating the file on the terminal/looking up the file in the folder but I honestly couldn't find any. I was quite bewildered as to where is the file saves on my mac. 

      Will keep digging online!

      Thanks though,

      Jane

      Like
Like Follow
  • 3 mths agoLast active
  • 6Replies
  • 8Views
  • 2 Following