I created a backup of my local PostgreSQL database and like to restore it in my cloud acceptance environment. The restore is successfull but when i restart the application i get the error: Core: Using password '1' for a user with administrator user roles is not allowed. The following admin users have password 1: [MxAdmin]
So i changed my MxAdmin password in my local system and deployed that version, but still the same error. Any suggestions.
Whole issue is related to the fact that the MxAdmin PW is only set to the modeler default when running locally.
Since you restore the local database in an environment which has PW control, you bump into this issue.
Just an option: restore other backups to accp. An prod-backup, an older accp-backup. See if it makes a difference. Quite similar to your second attempt, but opssibly worth a try.
Did you try setting the Admin password with the button highlighted below?