django.db.utils.OperationalError: FATAL: role "django" does not exist

You may see this error if you have postgres installed both locally (and running) and a docker container both trying to occupy the same port.

If the local instance starts first and is occupying a port that the docker image is also trying to use, docker won't necessarily tell you this.

When you try to run django or other ./manage.py commands that need the database you'll see the same error because the app will not see the database you're looking for.

In this case, you can change the port on your locally installed postgres by stopping the server, clicking Server Settings and changing the port. You'll have to update settings.py on any apps you have depending on that old port.

In my experience, after doing this if you restart the docker db container you won't see this error anymore.

Refer the link click here. It is explained.

Your settings has

'USER': 'django',

But as error says that user doesn't exist , that means you have not created the user.

Just go into interactive session of psql and enter these commands.

CREATE DATABASE agencies;
CREATE USER django WITH PASSWORD 'password';
ALTER ROLE django SET client_encoding TO 'utf8'; 
ALTER ROLE django SET default_transaction_isolation TO 'read committed'; 
ALTER ROLE django SET timezone TO 'Asia/Kolkata';

GRANT ALL PRIVILEGES ON DATABASE agencies TO django;
\q

then in settings.py

'PASSWORD': 'password',

password should not be enclosed inside < >.