Cant use

    'service': 'my_service',
    'passfile': '.pgpass',

So use decouple and tradional

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'dbms_db',
        'USER': 'dbms',
        'PASSWORD': DB_PASS,
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}