sql schema version compatibility check failed: pq: no pg_hba.conf entry for host "172.20.21.107", user "db_admin", database "temporal", no encryption

[lemaadi]

Hi,

I am deploying retool service with temporal cluster using this repository. I successfully deployed Retool service to aws ecs fargate cluster ( main backend, jobs runner, workflows worker, workflows backend) from this docker image tryretool/backend:3.16.7 with aws postgresql database version 15.4. But i am facing the following error

Unable to start server. Error: could not build arguments for function "go.uber.org/fx".(*App).constructCustomLogger.func2 (/go/pkg/mod/go.uber.org/fx@v1.17.1/app.go:415): failed to build fxevent.Logger: could not build arguments for function "go.temporal.io/server/temporal".glob..func8 (/home/builder/temporal/temporal/fx.go:921): failed to build log.Logger: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:163): sql schema version compatibility check failed: pq: no pg_hba.conf entry for host "172.20.21.107", user "db_admin", database "temporal", no encryption

when deploying Temporal cluster on aws ecs fargate services ( frontend, history, worker, matching) using this docker image tryretool/one-offs:retool-temporal-1.1.4 with aws postgresql 15.4 database.

More details can be found on this ticket

If you can help me to fix this error it would be much appreciated

I will be very happy to provide more details about the terraform code setup i am using

Thank you in advance

cc @roberto-retool