Datasentinel is a unique and innovative performance tool for Postgresql
This toolkit is composed of simple ansible playbooks and bash scripts. It is installed by default in the home directory
(/home/datasentinel) of the user datasentinel in the centralized platform.
For simplicity, all variables are defined in the header of each playbook
Ansible is a very popular tool and is installed by default on the Datasentinel platform
Connect as datasentinel on the platform server:
ansible --version
The update_agents.yml playbook is an example on how to update deployed agents with a new version
You need to download new versions and put them in the directory /datasentinel/download (local_dir variable)
Example
ansible-playbook update_agents.yml -i hosts
The Datasentinel documentation is available at www.datasentinel.io/documentation/
The API documentation is available at Activity API documentation
The activity_api playbook is an example on how to export activity metrics from Datasentinel
Example
ansible-playbook activity_api.yml -e "datasentinel_host=myHost datasentinel_password=myPassword" --tags indexes
This API allows you to generate a complete workload report in PDF format
The generate_pdf_report playbook is an example on how to generate a PDF file
Example
ansible-playbook generate_pdf_report.yml -e "datasentinel_host=myHost datasentinel_password=myPassword" --tags indexes
It uses the Agentless feature of Datasentinel
Only a user with data admin profile and admin privilege is authorized to use it
The connection_manager playbook creates, updates, enables, disables and finally deletes a connection
Example
ansible-playbook connection_manager.yml -e "datasentinel_host=myHost datasentinel_password=MyDatasentinelPassword pg_password=myPgPassword"
The bulk_load_connections playbook is an example on how to import multiple connections
Example
ansible-playbook bulk_load_connections.yml -e "datasentinel_host=myHost datasentinel_password=MyDatasentinelPassword pg_password=myPgPassword"
Only a user with data admin profile and admin privilege is authorized to use it
The user_api playbook creates, updates and deletes roles and users.
Example
ansible-playbook user_api.yml -e "datasentinel_host=myHost datasentinel_password=MyDatasentinelPassword
Example
./connection_manager_api.sh -d datasentinel_server -p password -u user
Example
./user_api.sh -d datasentinel_server -p password -u user
Example
./top_queries_report.sh -d datasentinel_server -p password -u user