CB Response: How To Re-Index the 'server_storage_stats' Table

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

How to re-index the 'server_storage_stats' Postgres table.

Environment

• CB Response Server: All Versions
• Clustered
• PostGres

Resolution

1. Stop all CB Response Services
2. Run following command on Master/Standalone server to start only Postgres service:

service cb-pgsql start

3. Run following command on Master/Standalone server to backup 'server_storage_stats' table:

/usr/bin/pg_dump -C -Fp -f /var/log/server_storage_stats.sql cb -p 5002 --table server_storage_stats

4. ​​​​​Run following command on Master/Standalone server to re-index 'server_storage_stats' table:

/usr/pgsql-9.3/bin/psql -p 5002 -d cb -c "REINDEX TABLE server_storage_stats;"

5. ​​​​​​​​​​​​Run following command on Master/Standalone server to stop Postgres service

service cb-pgsql stop

6. Re-start CB Response Server Services