I am trying to upgrade from 12.7.5 to 12.7.7 and doing the PostgreSQL credentials change. I go through the process of creating the new database user....etc. following the docs provided on Solarwinds Portal. Once I start the services. I can't establish connection to the database with the new credentials. I get this error
Unable to establish connection: FATAL: role "whd" does not exist.