Skip to content

Instantly share code, notes, and snippets.

@petebytes

petebytes/Pghero on Rails with Dokku.txt

Forked from monsha/Pghero on Rails with Dokku.txt
Created January 16, 2023 16:39
Show Gist options
  • Save petebytes/8730d4509ddd4f2b6f39c438d3443654 to your computer and use it in GitHub Desktop.
Save petebytes/8730d4509ddd4f2b6f39c438d3443654 to your computer and use it in GitHub Desktop.
Download ZIP
Pghero on Rails with Dokku
Raw
Pghero on Rails with Dokku.txt
#postgresql setup
ssh -i ~/.ssh/id_rsa root@<domain>
dokku postgres:connect <db>
psql=# SHOW config_file;
-> /var/lib/postgresql/data/postgresql.conf
psql=# \q
docker ps
docker cp <container>:/var/lib/postgresql/data/postgresql.conf .
#Add the following to postgresql.conf:
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
pg_stat_statements.max = 10000
track_activity_query_size = 2048
docker cp postgresql.conf <container>:/var/lib/postgresql/data/postgresql.conf
docker exec -ti <container> /bin/bash
root@24de23319cd7: cat /var/lib/postgresql/data/postgresql.conf
root@24de23319cd7: exit
#restart PostgreSQL.
docker restart <container>
# deploy
git push dokku master
dokku --rm run <app> bundle exec rake db:migrate
# Schedule cron:
*/5 * * * * dokku --rm run <app> bundle exec rails pghero:capture_query_stats && curl -fsS --retry 3 https://hchk.io/<token> > /dev/null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment