Clean up the standby system if you accidentally started Splunk UBA services
If you started Splunk UBA services on the standby system, the PostgreSQL logs can become very large and negatively affect performance.
Perform the follow tasks to work around this issue:
- Login to the management node on the standby system as the caspida user.
- Run the following command to stop Splunk UBA:
/opt/caspida/bin/Caspida stop
- Run the following command to stop PostgreSQL:
/opt/caspida/bin/Caspida stop-postgres
- As a user with root privileges, manually delete all the PostgreSQL logs on the PostgreSQL node. In 20-node deployments, PostgreSQL runs on node 2. In all other deployment sizes, PostgreSQL runs on node 1.
- In Ubuntu environments, PostgreSQL logs are located in
/var/log/postgresql/*
. - In RHEL or OEL environments, PostgreSQL logs are located in
/var/vcap/store/pgsql/10/data/pg_log
.
- In Ubuntu environments, PostgreSQL logs are located in
- Run the following command to start PostgreSQL:
/opt/caspida/bin/Caspida start-postgres
- Follow the instructions in Set up the standby Splunk UBA system to set up replication in the standby system again. Make sure you do not start any Splunk UBA services in the standby system.
Perform maintenance on your Splunk UBA clusters using warm standby | Recover Splunk UBA after an outage |
This documentation applies to the following versions of Splunk® User Behavior Analytics: 5.1.0, 5.1.0.1, 5.2.0, 5.2.1
Feedback submitted, thanks!