[Question posted by a user on YugabyteDB Community Slack]
I'm trying to connect my yugabytedb database with skyvia (as a PostgreSQL connection), but I'm getting the following error:
no pg_hba.conf entry for host "40.118.246.204", user "admin", database "skyvia_test", SSL off
According to skyvia docs, I have to add some lines to postgresql.conf and pg_hba.conf. Any idea how I would do this in yugabytedb? (link to skyvia docs page)
If you are using YugabyteDB Managed, make sure you're connecting with SSL enabled. Set ssl-mode to verify-full and provide the certificate that you can download from the portal:
If you're running on your premises, then you need to pass the ysql_hba_conf_csv flag with that IP to a tserver instance upon startup: https://docs.yugabyte.com/preview/secure/enable-authentication/ysql_hba_conf-configuration/.
This is a step-by-step video tutorial: https://youtu.be/zwQoM-ULNo8