Dotfiles, Shell Scripts and SQL statements that useful to Greenplum and PostgreSQL DBA on day to day activity. Few dotfiles I have copied from below repositories and have modified for Greenplum Database Users.
1️⃣ All required environment exports
2️⃣ Aliases to make work easier
3️⃣ Python autocomplete for vim
4️⃣ Python Script to get notified through email with waiters and blockers information if queries are in waiting state more that 10 minutes (Using gmail,outlook etc)
5️⃣ Shell script to get notified through email with waiters and blockers information if queries are in waiting state more that 10 minutes (Using Unix Mail Utility)
6️⃣ Shell script to archive the GPDB log files in pg_log/YEAR/MONTH directory
7️⃣ Greenplum Utility like logging using gplog.py from gpdb source code.
8️⃣ And More... 😊
mkdir $HOME/git
cd $HOME/git
git clone https://github.com/pgyogesh/greenplum.git
cd greenplum
chmod +x install.sh
./install.sh
And Relax..
Don't forget to source ~/.bash_profile after installation.