django postgres password authentication failed

Question

I am trying to connect Django with postgres but i am getting this error

this is my setting.py:

'default' : {
    'ENGINE' : 'django.db.backends.postgresql_psycopg2',
    'NAME' : 'login',
    'USERNAME' : 'postgres',
    'PASSWORD' :'123',
    'HOST' : 'localhost',
    'PORT' : '5432'
}

The user name in the error message (=> "tbosss") doesn't match your settings (=> "USERNAME: 'postgres'"). — bruno desthuilliers
– bruno desthuilliers, Commented Dec 26, 2018 at 11:46
I repeat: The user name in the error message (=> "tbosss") doesn't match your settings (=> "USERNAME: 'postgres'"). Either you're using different settings than those you posted or you're trying to manually connect to the db at some point with a different username, but in both cases no one can help you debug this kind of problem without correct informations (and even then - postgres is kind of PITA when it comes to permissions). — bruno desthuilliers
– bruno desthuilliers, Commented Dec 26, 2018 at 12:33
@c.grey this should be "ATOMIC" (not "ATOMATIC"), and it won't solve the problem anyway. — bruno desthuilliers
– bruno desthuilliers, Commented Dec 26, 2018 at 12:34

Yavuz Selim · Accepted Answer · 2018-12-27 07:45:29Z

2

psql (default client for PostgreSQL) tries to connect with current OS user when no user specified and I think that psycopg2 does that too.

The PostgreSQL documentation contains the complete list of the supported parameters. Also note that the same parameters can be passed to the client library using environment variables.

http://initd.org/psycopg/docs/module.html

https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

When I check psycopg2 tutorial, I see that USERNAME option must be changed to USER.

psycopg2.connect("dbname='template1' user='dbuser' host='localhost' password='dbpass'")

https://wiki.postgresql.org/wiki/Psycopg2_Tutorial

edited Dec 27, 2018 at 7:45

answered Dec 27, 2018 at 7:36

Yavuz Selim

5462 gold badges7 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

django postgres password authentication failed

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