FATAL: no pg_hba.conf entry for host "xxx", user "hydra", database "hydra", no encryption (SQLSTATE 28000))

[atliuhui]

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

No response

Describe the bug

migration error, using Azure Postgres service

Reproducing the bug

WIndows Powershell

1. .\hydra.exe migrate sql -y postgres://hydra:xxx@xxx.postgres.database.azure.com:5432/hydra?sslmode=disable

Relevant log output

time=2024-05-07T12:46:01+08:00 level=info msg=No tracer configured - skipping tracing setup audience=application service_name=Ory Hydra service_version=v2.2.0
time=2024-05-07T12:46:01+08:00 level=info msg=Retrying in 0.100000 seconds... audience=application error=map[message:failed to connect to `host=xxx.postgres.database.azure.com user=hydra database=hydra`: server error (FATAL: no pg_hba.conf entry for host "xxx", user "hydra", database "hydra", no encryption (SQLSTATE 28000))] service_name=Ory Hydra service_version=v2.2.0

Relevant configuration

No response

Version

2.2.0

On which operating system are you observing this issue?

None

In which environment are you deploying?

None

Additional Context

No response