Argthtjtr

in first: sorry for this duplicate, but the others similar questions related for this issue always tell the same method to fix this problem, but did don't works for me.I trying to migrate a DB from sqlite to postgresql...so I type:

sudo -u postgres psql

postgres=# ALTER USER postgres WITH PASSWORD 'newpassword';

and the output return: "ALTER ROLE"

but when I type "python manage.py migrate" I receive always the same error:

django.db.utils.OperationalError: FATAL: password authentication
failed for user "douglas"

settings.py:

# Application definition



INSTALLED_APPS = [

    'django.contrib.admin',

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'app',

]



MIDDLEWARE = [

    'django.middleware.security.SecurityMiddleware',

    'django.contrib.sessions.middleware.SessionMiddleware',

    'django.middleware.common.CommonMiddleware',

    'django.middleware.csrf.CsrfViewMiddleware',

    'django.contrib.auth.middleware.AuthenticationMiddleware',

    'django.contrib.messages.middleware.MessageMiddleware',

    'django.middleware.clickjacking.XFrameOptionsMiddleware',

]



ROOT_URLCONF = 'site_.urls'



TEMPLATES = [

    {

        'BACKEND': 'django.template.backends.django.DjangoTemplates',

        'DIRS': ,

        'APP_DIRS': True,

        'OPTIONS': {

            'context_processors': [

                'django.template.context_processors.debug',

                'django.template.context_processors.request',

                'django.contrib.auth.context_processors.auth',

                'django.contrib.messages.context_processors.messages',

            ],

        },

    },

]



WSGI_APPLICATION = 'site_.wsgi.application'





# Database

# https://docs.djangoproject.com/en/1.10/ref/settings/#databases



"""

DATABASES = {

    #'default': {

    #    'ENGINE': 'django.db.backends.sqlite3',

    #    'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),

    #}

    'default': dj_database_url.config(default='postgres://localhost:5432/postgres_db_name'),

}

"""





DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.postgresql',

        'NAME': 'douglas_db',

        'USER': 'douglas',

        'PASSWORD': 'vamointer',

        'HOST': '127.0.0.1',

        'PORT': '5432',

    }

}

# Password validation

# https://docs.djangoproject.com/en/1.10/ref/settings/#auth-password-validators



#DATABASES = {'default': dj_database_url.config(default='postgres://127.0.0.1:5432/postgres_db_name')}



AUTH_PASSWORD_VALIDATORS = [

    {

        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',

    },

]





# Internationalization

# https://docs.djangoproject.com/en/1.10/topics/i18n/



LANGUAGE_CODE = 'pt-br'



TIME_ZONE = 'America/Sao_Paulo'



USE_I18N = True



USE_L10N = True



USE_TZ = True





# Static files (CSS, JavaScript, Images)

# https://docs.djangoproject.com/en/1.10/howto/static-files/



STATIC_URL = '/static/'

STATIC_ROOT = os.path.join(BASE_DIR, 'static')

ps: When I run the 'ALTER USER postgres WITH PASSWORD' I put the same password defined in the settings.py.

Thanks!

The SQL you are running does not match the user you are attempting to use.

You will need to create the user if it does not exist

CREATE USER douglas WITH PASSWORD 'vamointer';

or if it does exist, change that users password instead.

ALTER USER douglas WITH PASSWORD 'vamointer';

Once you have done that you should have more luck. You may need to assign permissions to that user as well.

Special characters in postgresql are converted to different characters while execution. Make sure you do not have special characters (#,$,etc..) in your password.

If you do, change the postgresql password as follows:

sudo -u postgresql psql

postgresql=#alter yourusername with password 

'set_new_password_without_special_character';

Make sure you do not forget the ; at the end of postgresql command.
Then run python manage.py and it should work!