Hello! We recently upgraded from Postgres 11.22 to 16.3. We run metaflow in ECS in AWS using the terraform module to spin it up. Initially everything worked well but when the metadata-service restarted, we started getting errors:

[Errno 111] Connection refused
Exception: unable to get db version via goose: 2024/10/09 05:22:57 goose run: pq: no pg_hba.conf entry for host "10......", user "metaflow", database "metaflow", no encryption

Did anyone run this version of Postgres successfully? And any idea on how to solve the issue?

hi! do you have ssl_enabled for your service container?