[Solved] 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. 

[KazVee]

Looks like your account was moved to a new server on Sept 23 2024, probably because of the server upgrade that happened during that time. 

I can't see if your account has remote access currently, but server moves will remove the remote access, so I suspect that's what happened here since the "no pg_hba.conf entry for host" error matches the usual indicator that remote access is not enabled. 

I'm escalating this thread so a root admin can set up the remote access for you.

[Krydos]

Remote access enabled.

host=65.19.154.90
port=5432
user=kkaviani_admin
dbname=kkaviani_poems
password=<set in Plesk>

 

[kkaviani]

Thank you!