{"type":"doc","content":[{"type":"paragraph","content":[{"text":"There are two postgresql databases ","type":"text"},{"text":"kfuse-configdb","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"orchestrator-postgresql","type":"text","marks":[{"type":"code"}]},{"text":" that Kloudfuse installation uses and both are using the default password obtained from ","type":"text"},{"text":"kfuse-pg-credentials","type":"text","marks":[{"type":"code"}]},{"text":" secret.","type":"text"},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"If you wish to update the default password for postgresql, it can be updated with following steps","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get the default password with following steps","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"kubectl -n kfuse get secret kfuse-pg-credentials -o yaml \n\napiVersion: v1\ndata:\n postgres-password: <>\n postgresql-password: <>\n postgresql-postgres-password: <>\n postgresql-replication-password: <>\nkind: Secret\nmetadata:\n.\n.\n.","type":"text"}]},{"type":"orderedList","attrs":{"order":2},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Decrypt the default password","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"echo -n <> | base64 -d \n# Ignore the end character %","type":"text"}]},{"type":"orderedList","attrs":{"order":3},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login to ","type":"text"},{"text":"kfuse-configdb","type":"text","marks":[{"type":"code"}]},{"text":" and change the default postgres password","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"kubectl -n kfuse exec -it kfuse-configdb-0 -- bash\nI have no name!@kfuse-configdb-0:/$ psql -U postgres\nPassword for user postgres:\npsql (14.11)\nType \"help\" for help.\n\npostgres=# \\password postgres\nEnter new password for user \"postgres\":\nEnter it again:\npostgres=# exit","type":"text"}]},{"type":"orderedList","attrs":{"order":4},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login to ","type":"text"},{"text":"orchestrator-postgresql","type":"text","marks":[{"type":"code"}]},{"text":" and change the default postgres password","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"kubectl -n kfuse exec -it orchestrator-postgresql-0 -- bash\nI have no name!@orchestrator-postgresql-0:/$ psql -U postgres\nPassword for user postgres:\npsql (14.11)\nType \"help\" for help.\n\npostgres=# \\password postgres\nEnter new password for user \"postgres\":\nEnter it again:\npostgres=# exit","type":"text"}]},{"type":"orderedList","attrs":{"order":5},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Base64 Encode the new password ","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"echo -n \"<>\" | base64","type":"text"}]},{"type":"orderedList","attrs":{"order":6},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit the existing ","type":"text"},{"text":"kfuse-pg-credentials","type":"text","marks":[{"type":"code"}]},{"text":" secret and update with new base64 encoded password","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"kubectl -n kfuse edit secrets kfuse-pg-credentials","type":"text"}]},{"type":"orderedList","attrs":{"order":7},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the dependent services to update with the new password","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"shell"},"content":[{"text":"kubectl rollout restart statefulset kfuse-configdb logs-parser logs-query-service orchestrator-postgresql pinot-broker pinot-controller pinot-server-offline\nkubectl rollout restart deployment advance-functions-service beffe events-query-service ingester kfuse-grafana logs-transformer query-service trace-query-service trace-transformer","type":"text"}]}],"version":1}

Browser not supported