(Responding to the error/screenshot quoted)
This might not fix it for you, but have you checked if the applicable dev &/or production IPs have been added on Digital Ocean? How to Secure PostgreSQL Managed Database Clusters :: DigitalOcean Documentation
In case the link doesn't take you there directly, it is under "Add a Trusted Source using the Control Panel"
Edit: Also worth adding, I have had times where I needed to manually download the relevant certs following these instructions