I get the error role "<my-username>" does not exist when starting a rule processor. Why?

This happens when the database user environment variables are incorrectly set. A common mistake is accidentally reusing the RAW_HISTORY_DATABASE_USER variable name for CONFIGURATION_DATABASE_USER. Make sure each database section in your .env has its own explicit USER variable, e.g. CONFIGURATION_DATABASE_USER=postgres - do not inherit or alias across sections.