I hereby claim:
- I am turgs on github.
- I am timburgan (https://keybase.io/timburgan) on keybase.
- I have a public key ASC50q_kl6ohdUvZfuNCLGKq2N6JLYFXLs14LUg9T6kfXgo
To claim this, I am signing this object:
| # CLI | |
| sudo apt update -y | |
| sudo apt install -y \ | |
| git curl docker.io \ | |
| build-essential pkg-config autoconf bison rustc cargo clang \ | |
| libssl-dev libreadline-dev zlib1g-dev libyaml-dev libreadline-dev libncurses5-dev libffi-dev libgdbm-dev libjemalloc2 \ | |
| libvips imagemagick libmagickwand-dev \ | |
| redis-tools sqlite3 libsqlite3-0 libmysqlclient-dev \ | |
| rbenv apache2-utils | 
I hereby claim:
To claim this, I am signing this object:
#Bot-Buster™
Tracks nefarious activity on website, and manages accordingly.
##It's probably a bot.
If the requesting entity:
| # dump all databases once every 24 hours | |
| 45 4 * * * root nice -n 19 su - postgres -c "pg_dumpall --clean" | gzip -9 > /var/local/backup/postgres/postgres_all.sql.gz | |
| # vacuum all databases every night (full vacuum on Sunday night, lazy vacuum every other night) | |
| 45 3 * * 0 root nice -n 19 su - postgres -c "vacuumdb --all --full --analyze" | |
| 45 3 * * 1-6 root nice -n 19 su - postgres -c "vacuumdb --all --analyze --quiet" | |
| # re-index all databases once a week | |
| 0 3 * * 0 root nice -n 19 su - postgres -c 'psql -t -c "select datname from pg_database order by datname;" | xargs -n 1 -I"{}" -- psql -U postgres {} -c "reindex database {};"' |