Connecting to a external postgresql database

[r_m]

hi,

I would like to connect my web application (written in django) to a external postgresql database.
Can in be done? My guess is that I need to edit the enviroment variable

DATABASE_URL

using the a syntax similar to:

postgres://user:pass@host/dbname

Am I right or am I missing something? Is render firewall filtering some ports?

           thanks for the help

[al_ps]

Hi there,

Thanks for reaching out.

Yes, if you Django app utilises a standard Postgres connection string, it would be along the lines of

postgres://USER:PASSWORD@HOST:PORT/DATABASE

These details would come from your Postgres provider and you’d need to ensure it permits connections from Render/the public internet.

Kind regards

Alan