how to connect Django in EC2 to a Postgres database in RDS?

Question

First time using AWS services with Django.

Was wondering how to configure the Django app running in a EC2 instance to a Postgres database in RDS?

the EC2 is running ubuntu 14.04

Any special configuration required?

from time to time I get a plus on the answer below, it would be nice for me and the community if you'd accept the answer even though I assume it did not help you personally (due to time difference) — bluesummers

bluesummers bluesummers · Accepted Answer · 2017-08-21T08:16:06

All you need to do, before doing the normal migration documented in the official tutorial be sure to have your RDS instance available and accessible to your EC2 instance.

Then what you need to do, is to modify the settings.py file of your app in the DATABSES section in the following way

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql',
    'NAME': '<name defined upon RDS creation>',
    'USER': '<username defined upon RDS creation>',
    'PASSWORD': '<password defined upon RDS creation>',
    'HOST': '<this can be found in "Endpoint" on your RDS dashboard, exclude the ":" and the port number>',
    'PORT': '5432',
    }
}

Following this, continue to migrate normally and all should work well.

how to connect Django in EC2 to a Postgres database in RDS?

2 Answers