has anyone encountered this , i am able to connect to DB using my temp pod though

│ flyte 2025/09/30 22:40:48 /flyteorg/build/datacatalog/pkg/repositories/config/postgres.go:75                                                                                                                                                                                         │
│ flyte [error] failed to initialize database, got error driver: bad connection                                                                                                                                                                                                        │
│ flyte {"json":{"src":"initialize.go:32"},"level":"error","msg":"Failed to cast error of type: *errors.errorString, err: driver: bad connection","ts":"2025-09-30T22:40:48Z"}                                                                                                         │
│ flyte panic: driver: bad connection

Looks like bad subnet or something

Exec into the pod and try the connection It appears to be a network issue. If the connection works the see if you have the correct env variable and secrets mounted:

kubectl get pod <pod-name> -n <namespace> -o yaml

You have to decode the secret to get the value. Check if the database in on and accepting connection request