[Solved] emote access of PostgreSql database

[slimsim]

Hi,

 

Please can you assist me with enabling remote access on my PostgreSql database?

 

I've tried to connect with pgAdmin4, and enters the following information:

Name: slimsim_ava_db_dev_1

Host name / address: johnny.heliohost.org

Port: 5432

Maintenance database: postgresql

Username: slimsim_db_user

 

 

This is error i get when trying to connect:

Unable to connect to server:

FATAL: no pg_hba.conf entry for host "92.34.255.150", user "slimsim_db_user", database "postgresql", SSL off

Thanks!

 

[flazepe]

This support request is being escalated to our root admins.

[Krydos]

user "slimsim_db_user", database "postgresql"

You need to specify your database name, not the postgresql database.

[slimsim]

Thanks for the help!
 

When I try with the following information in pgAdmin4:

Name: slimsim_ava_db_dev_1

Host name / address: johnny.heliohost.org

Port: 5432

Maintenance database: slimsim_ava_db_dev_1

Username: slimsim_db_user

 

I get 

Unable to connect to server:

FATAL: no pg_hba.conf entry for host "92.34.255.150", user "slimsim_db_user", database "slimsim_ava_db_dev_1", SSL off

If I try the same information but use port 3306 i get:

Unable to connect to server:
received invalid response to SSL negotiation: J

Do you know what the problem is?
What port should I use?

 

Thanks so much for the help!

[Krydos]

Remote access enabled.

 

Port 5432 is postgresql. Port 3306 is mysql.