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, Commented Jun 1, 2019 at 5:49

Bruce Wayne · Accepted Answer · 2022-09-03 06:56:08Z

24

All you need to do before doing the normal migration documented in the official tutorial is to 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 DATABASES 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.

edited Sep 3, 2022 at 6:56

Bruce Wayne

1041 silver badge10 bronze badges

answered Aug 21, 2017 at 8:16

bluesummers

12.8k10 gold badges81 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

awwester · Accepted Answer · 2015-04-29 00:58:35Z

0

If you are able to use a deployment service, take a look at at AWS Elastic Beanstalk. It combines EC2, RDS and S3 storage into a Docker and helps keep them together. It's really easy to connect your RDS instance to your EC2 instance(s). I just launched a Django project using that a few weeks ago.

answered Apr 29, 2015 at 0:58

awwester

10.2k13 gold badges48 silver badges74 bronze badges

7 Comments

Kim Stacks Over a year ago

What you mean by deployment service?

awwester Over a year ago

Amazon has some services that combine groups of services and ease deployment/maintenance (such as EC2 + RDS + S3). There are a couple, but EB was the most straightforward to me, especially with projects written in Python.

Kim Stacks Over a year ago

Do you have any good tutorial on this? Particularly for django projects

awwester Over a year ago

I found realpython.com/blog/python/… to be the best. It's still a little outdated as EB now supports python 3. Also when you get to the section about handling database migrations use stackoverflow.com/questions/29540131/…

Kim Stacks Over a year ago

I am a Docker newbie and a EB newbie. I found the realpython.com/blog/python/… not to use Docker. Should I use Docker?

|

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related