Different PostgreSQL database: local and remote | Django

Question

I've just configured my remote PostgreSQL database @ Elephant but now I'd like to also set the local PostgreSQL connection in order to make some tests before going online (remote db).

This is my settings.py:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': '***',  
        'USER': '***',   
        'PASSWORD': '***',   
        'HOST': 'lallah.db.elephantsql.com',  
        'PORT': '5432', 
    }
}

How can I update the settings.py to also let me use the localhost PostgreSQL connection without erasing the elephant configurations?

Thank you!

Does the localhost server have a replica setup of the remote? If so follow instructions here Multiple databases — Adrian Klaver
– Adrian Klaver, Commented Nov 1, 2020 at 20:30
@AdrianKlaver as far as I know, I didn't set up any replica. In the replica (localhost), can I makemigrations & migrate without disturbing the remote server? — Felipe Dourado
– Felipe Dourado, Commented Nov 1, 2020 at 20:41
Rather then copying the Django docs, I would suggest you read the information at the link I posted. It covers migrations as well as a lot of other things relative to this. The other option is to create an entirely different settings.py and point at that for local use. — Adrian Klaver
– Adrian Klaver, Commented Nov 1, 2020 at 21:13

Alexey Popov · Accepted Answer · 2020-11-01 21:44:27Z

1

The most common approach is to have something like local_settings.py in your project that is not a part of production dist (gitignored etc). You can define your local settings there, not only db, but caches, compress options and many more and then override production settings in main settings.py by import:

if DEBUG == True:
    from .local_settings import DATABASES, CACHES # and whatever else you want

answered Nov 1, 2020 at 21:44

Alexey Popov

7564 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Different PostgreSQL database: local and remote | Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related