Ubuntu connection issue with Postgres DB

Hi there,

I’m receiving this message “org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “XXX.XXX.XXX.XXX”, user “username”, database “dbname”, SSL off”

connecting to PostgreSQL.

Ubuntu 16.04 running the “jar” file

MetaBase and PostgreSQL are installed on different machines but they can communicate over TCP and port 5432

Thanks,

Ricardo

Sorry guys. It was an error in my ( pg_hba.conf ) configuration file.

One must include

host all all xxx.xxx.xxx.xxx/32 md5

in the configuration file, where xxx.xxx.xxx.xxx is the IP address for the remote host.

This configuration is related to PostgreSQL remote access.

Thank you,

Ricardo Jorge

i’m going to try to see if this is going to work for my problem as well. but if it won’t then could you be able to help me please ricardoj? it seems you know a little bit better than me these things