[Solved] Connect to PostgreSQL DB

[cm1291]

Good day! I am attempting to connect to my newly created PostgreSQL database and am encountering an error:

Unable to connect to server: connection failed: connection to server at "65.19.154.90", port 5432 failed: FATAL: no pg_hba.conf entry for host "73.230.168.44", user "cm1291_pg", database "cm1291_nfl", SSL on connection to server at "65.19.154.90", port 5432 failed: FATAL: no  no pg_hba.conf entry for host "73.230.168.44", user "cm1291_pg", database "cm1291_nfl", SSL off

According to many past topics, root admin Krydos is needed to enable this on my account. Please let me know if this is possible. Thank you!

[wolstech]

Yeah this is disabled by default for security. Looks like database cm1291_nfl and user cm1291_pg based on the errors.

Escalating to have it enabled for you  

[cm1291]

Thanks! Will this be enabled for any future databases I create or will I also need to submit separate requests for those new databases?

[wolstech]

It has to be enabled for each database. If you need more than one, you can just create the databases now and add them here so he can do them all at once.

[cm1291]

I just created one more, cm1291_mlb. I'll need that as well as cm1291_nfl. Thanks again!

[Krydos]

Remote access enabled.

host=65.19.154.90
port=5432
user=cm1291_pg
dbname=cm1291_mlb
password=<set in Plesk>

host=65.19.154.90
port=5432
user=cm1291_pg
dbname=cm1291_nfl
password=<set in Plesk>