Hi team
I am trying to migrate the local postgresql in the docker container to an externally host Postgresql RDS on AWS. Follow precisely the instructions listed here -> Configure and migrate to an external database | Retool Docs. But I am unable to launch retool afterwards.
Dig into the log docker-compose logs showing the following. I have a feeling that this is related to SSL and certificate. Could anyone advise how this can be resolved?
Thanks.
Henry
Hi Henry,
This sounds like a wrong or missing environment variable somewhere. Retool should be able to work with RDS over SSL natively without installing any extra certs, but it looks like it's trying to connect without using SSL. Can you make sure POSTGRES_SSL_ENABLED=true is set (and POSTGRES_SSL_DISABLED is not set) in your env file?
If that doesn't help, it would help to see your whole docker.env file (without anything secret) and whether the same database credentials work if you shell into the backend container and connect via psql.
Ryan
