Skip to content

Instantly share code, notes, and snippets.

@devjah

devjah/Pghero on Rails with Dokku.txt

Forked from monsha/Pghero on Rails with Dokku.txt
Created February 4, 2023 12:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save devjah/77576b72e5b22e1a96b3807887a70fe1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save devjah/77576b72e5b22e1a96b3807887a70fe1 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