How to indicate to a specific version of database? [Django] [PostgreSQL]

Question

I using django version 3.0.2. I'd like to use postgreSQL as my instance db.

And there are two version postgreSQL in server.

After config setting.py DATABASES parameter, and runserver. It showed error.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'dj_web_console',
        'USER': 'django',
        'PASSWORD': 'django',
        'HOST': 'localhost',
        'PORT': '',
    }
}

psycopg2.OperationalError: FATAL: password authentication failed for user "django"

I'm sure that the username and password are correct.

How to config pg_path in Django as odoo:

In this case, I can use the specific version of pgsql. And run smoothly.

Django isn't starting Postgres. You should be starting the Postgres server yourself, at which point you can decide what version to start. — deceze
– deceze ♦, Commented Sep 2, 2020 at 7:51
How and where to set it? I can understand what you say. In my case, I have a "9.6" version of pg with db named "A", the other version is 12 with db named "B", If I set the DATABASE parameter to A (version "9.6"), It can run!! But I can not set it to B. It will cause an error. — Terrence Poe
– Terrence Poe, Commented Sep 3, 2020 at 0:58

Terrence Poe · Accepted Answer · 2020-09-04 00:48:48Z

2

I solve this by indicating the port of the version I installed. In this case, I have a version 9.6 which install in 5432 and the other is 5433. So I just solved this by filling in 5433.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'dj_web_console',
        'USER': 'django',
        'PASSWORD': 'django',
        'HOST': 'localhost',
        'PORT': '5433',
    }
}

answered Sep 4, 2020 at 0:48

Terrence Poe

6444 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to indicate to a specific version of database? [Django] [PostgreSQL]

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