configuration of postgresql in Django project

Asked Aug 27 '14 at 08:44

Active Aug 27 '14 at 08:44

Viewed 76 times

I'm trying to configure the postgresql in django project, here is my settings

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

when I run syncdb command it gives the error "OperationalError: FATAL: Ident authentication failed for user "vishnu"". I tried the answers given in this link "psql: FATAL: Ident authentication failed for user "postgres"" as well several other links but its still giving me the error.

what is the problem how can I fix it?

edited May 23 '17 at 12:27

Community

asked Aug 27 '14 at 08:44

Vishnukant Tripathi

edit the pg_hba.conf file .. give `trust` to all connection – Raja Simon Aug 27 '14 at 09:09
1

@rajasimon bad idea. very insecure. set a password for the desired users then switch back md5 authentication. – DrColossos Aug 27 '14 at 10:44
thanks for concerning my question. I already used trust as well as md5 but still getting same error; after that only i posted the question. – Vishnukant Tripathi Aug 27 '14 at 10:50

configuration of postgresql in Django project

0 Answers0