WORKAROUND:
How to change the embedded postgresql default password for foglight user, Login into the OS
with your foglight user and follow this steps:
1. Stop the FMS service. <Foglight_Home>/bin/fms -q
2. Start Standalone PostgreSQL service:
$FGLHOME/bin/runDB.sh
3. Go to <Foglight_Home>/postgresql/bin/
4. Connect to Foglight database:
./psql -U foglight -p 15432 -d foglight
5.Change the foglight database password, example:
ALTER ROLE foglight WITH PASSWORD 'your_password_here';
4. logout from postgresql with \q
5. Shutdown the postgresql standalone db either:
$FGLHOME/bin/shutdownDb.sh
6. Update the password configuration on the FMS config file and restart the FMS following this KB: