便利ツール

Percona Toolkit
https://www.percona.com/software/database-tools/percona-toolkit

 

Tanel Poder's Troubleshooting Scripts
https://github.com/tanelpoder/tpt-oracle

 


Postgres Toolkit
https://github.com/uptimejp/postgres-toolkit


-- インストール方法 (CentOS7 PostgreSQL9.4)

yum install python-sphinx
yum install python-pip
pip install --upgrade pip

su - postgres

export SPHINXBUILD=/usr/bin/sphinx-build
export PATH=$PATH:/usr/pgsql-9.4/bin


git clone https://github.com/uptimejp/postgres-toolkit.git
cd postgres-toolkit
make

pip install -e .

cd /var/lib/pgsql/.local/bin
ls -l
./pt-config get shared_buffers

 

tigertoolbox
https://github.com/microsoft/tigertoolbox