Database autotuningΒΆ
The Plixer Endpoint Analytics database is automatically tuned to suit available system resources during the initial installation process.
The autotuning script can also be run manually when and as needed via CLI.
To run the script, open an SSH session to the appliance and change directory to /usr/beacon/scripts/maint
.
From there, run the following script:
./db_config_manager
The database autotuning script has the following settings that can be changed:
Setting |
Description |
Flag |
---|---|---|
Auto |
Adjusts postgresql.conf automatically based on hardware |
-a |
Reset |
Resets postgresql.conf to factory default |
-r |
Size |
Deploys preconfigured postgresql.conf based on standard database sizing |
-s (S|M|L) |
Help |
Displays command help |
-h |