Posts

Showing posts from June, 2019

Connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host

Add or edit the following line in your  postgresql.conf  : listen_addresses = '*' Add the following line as the first line of  pg_hba.conf . It allows access to all databases for all users with an encrypted password: # TYPE DATABASE USER CIDR-ADDRESS METHOD host all all 0.0.0.0 / 0 md5 Restart Postgresql after adding this with  service postgresql restart  or the equivalent command for your setup.