How to connect to the remote postgres database with pgAdmin?

[kkaviani]

Hi,

I have a pg database that my app uses, and I would like to connect to it via pgAdmin. I used to do this about a year or two ago, but I don't have the conection string anymore. If I just try the ip address of the site for host name, I get 

connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off

If I try tommy.heliohost.org as hostname, I get 

connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off Multiple connection attempts failed. All failures were: - host: 'tommy.heliohost.org', port: '5432', hostaddr: '2001:470:1:1ee::1002': connection failed: connection to server at "2001:470:1:1ee::1002", port 5432 failed: FATAL: no pg_hba.conf entry for host "2607:f140:400:13b:e8de:c71f:985d:ad55", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "2001:470:1:1ee::1002", port 5432 failed: FATAL: no pg_hba.conf entry for host "2607:f140:400:13b:e8de:c71f:985d:ad55", user "kkaviani_admin", database "kkaviani_poems", SSL off - host: 'tommy.heliohost.org', port: '5432', hostaddr: '65.19.154.90': connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "136.152.214.87", user "kkaviani_admin", database "kkaviani_poems", SSL off

I know Heliohost has recently went through some changes. Is this something you have to enable again?

Please help me connect remotely to this database: kkaviani_poems, user kkaviani_admin.