Which is USERNAME and PASSWORD should I put no `DBBACKUP_CONNECTORS`?

[rightx2]

I use PostgreSQL 9.5 and use md5 authentication

I set my system User ID and password on DBBACKUP_CONNECTORS settings.

DBBACKUP_CONNECTORS = {
    'default': {
        'USER': 'rightx2',
        'PASSWORD': 'MY_SYSTEM_PASSWD',
    }
}

Whenever I execute command, python manage.py dbbackup, it occurred errors:

dbbackup.db.exceptions.CommandConnectorError: Error running:  pg_dump super_trading --host=localhost --port=5432 --username=rightx2 --no-password --clean
b'pg_dump: [archiver (db)] connection to database "super_trading" failed: FATAL:  password authentication failed for user "rightx2"\nFATAL:  password authentication failed for user "rightx2"\n'

I wonder what I should put on USER and PASSWORD in DBBACKUP_CONNECTORS

[ZuluPro]

Obviously you must set you database password and user in these settings.
But are sure about your settings ? Does it work with your default database settings ?

[rightx2]

@ZuluPro If I removed DBBACKUP_CONNECTORS part in my settings and run python manage.py dbbackup, same error occurs,

dbbackup.db.exceptions.CommandConnectorError: Error running:  pg_dump super_trading --host=localhost --port=5432 --username=rightx2 --no-password --clean
b'pg_dump: [archiver (db)] connection to database "super_trading" failed: FATAL:  password authentication failed for user "rightx2"\nFATAL:  password authentication failed for user "rightx2"\n'

So I have checked whether my database's method of authentication is really md5 .

My default datbase settings:

DATABASES['default'] = dj_database_url.config(
    default="postgres://rightx2:MY_DB_PASSWD!@localhost:5432/super_trading"
)

And I tried to change username from rightx2 to asdf and run python manage.py makemigrations & migrate, it occurred errors too,

    self.connection = self.get_new_connection(conn_params)
  File "/home/rightx2/.pyenv/versions/super_trading_project/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/home/rightx2/.pyenv/versions/super_trading_project/lib/python3.6/site-packages/psycopg2/__init__.py", line 130, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL:  password authentication failed for user "asdf"
FATAL:  password authentication failed for user "asdf"

Makefile:2: recipe for target 'migrate' failed
make: *** [migrate] Error 1

I did the same test for the password, it occurred the same error, too.

According to this, I'm sure that the way of authenticating is md5.

But python manage.py dbbackup still doesn't work and I don't know why...

[rightx2]

Seems like it didn't read MY_DB_PASSWD in the settings according to dbbackup.db.exceptions.CommandConnectorError: Error running: pg_dump super_trading --host=localhost --port=5432 --username=rightx2 --no-password --clean

[pawisoon]

I'm having the same issue as op

Can you tell if you solved the problem?

Resolvi el problema, se tiene que instalar la version anterior de db-backup.

pip uninstall django-dbbackup
pip install django-dbbackup==3.0

[Nielssie]

Had the same problem.
postgres (PostgreSQL) 10.12 (Ubuntu 10.12-0ubuntu0.18.04.1)
downgraded from 3.2.0 --> 3.0
Fixed

[NoahRR]

@rightx2 did you ever find a solution to this? I'm getting the same error that you initially put (seems to not be recognizing the password I inputted in DBBACKUP_CONNECTORS)

[jonathan-s]

Note to self: https://dba.stackexchange.com/a/243220/132631