I made a postgres instance on render and am trying to connect to my database externally, however I am getting this error
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at “dpg-ck0mhij6fquc73862au0-a.oregon-postgres.render.com” (35.227.164.209), port 5432 failed: Connection timed out (0x0000274C/10060)
Is the server running on that host and accepting TCP/IP connections?
You’d need to plug these details into SQLAlchemy. Which I think also requires the scheme to be postgresql:// (not postgres://). You’ll also need to ensure the SSL mode is set to true/require.
Lastly, ensure the Access Control settings on the database are set as expected, e.g. correct/valid IP range.
Thanks for the reply.
I have all of that setup already. How would I check/change the ssl mode? The Access control list i have right now is set to 0.0.0.0/0. is that correct?