By Dow Drake
I’m following the Django/Nginx/postgresql tutorial which is great, but assumes that I want the database on the droplet. Instead, I have a database cluster that I want my Django app to connect to, but I’m not sure if I need to specify the port in my Django settings, and if so, whether I need to open that port in ufw. So far, everything I’ve read has to do with external connections.
Thanks for any help on this!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
Hi there,
To connect your Django application to an external Managed database cluster, you will indeed need to specify the database’s host and port in your Django settings. Here’s an example of how you might configure the Django DATABASES
setting:
~/myprojectdir/myproject/settings.py
:. . .
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'myproject',
'USER': 'myprojectuser',
'PASSWORD': 'password',
'HOST': 'YOUUR_DATABASE_HOST',
'PORT': 'YOUR_DATABASE_PORT',
}
}
. . .
With that said, you can skip the Creating the PostgreSQL Database and User
step from the tutorial.
Also, you will need to make sure that your Droplet’s IP address is added to the Database cluster Trusted sources:
https://docs.digitalocean.com/products/databases/postgresql/how-to/secure/
Let me know if you have any questions!
Best,
Bobby
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.