image/discourse_dev/postgres_dev.template.yml

   1 run:
   2   - exec:
   3       background: true
   4       # use fast shutdown for pg
   5       stop_signal: INT
   6       cmd: HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/9.5/bin/postmaster -D /etc/postgresql/9.5/main
   7
   8   - exec:
   9       background: true
  10       cmd: exec chpst -u redis -U redis /usr/bin/redis-server /etc/redis/redis.conf
  11
  12   # give db a few secs to start up
  13   - exec: "sleep 5"
  14
  15   - exec: su postgres -c 'createdb discourse_development' || true
  16   - exec: su postgres -c 'psql discourse_development -c "grant all privileges on database discourse_development to discourse;"' || true
  17   - exec: su postgres -c 'psql discourse_development -c "alter schema public owner to discourse;"'
  18   - exec: su postgres -c 'psql discourse_development -c "create extension if not exists hstore;"'
  19   - exec: su postgres -c 'psql discourse_development -c "create extension if not exists pg_trgm;"'
  20
  21   - exec: su postgres -c 'createdb discourse_test' || true
  22   - exec: su postgres -c 'psql discourse_test -c "grant all privileges on database discourse_test to discourse;"' || true
  23   - exec: su postgres -c 'psql discourse_test -c "alter schema public owner to discourse;"'
  24   - exec: su postgres -c 'psql discourse_test -c "create extension if not exists hstore;"'
  25   - exec: su postgres -c 'psql discourse_test -c "create extension if not exists pg_trgm;"'
  26   - exec: cd tmp && git clone https://github.com/discourse/discourse.git --depth=1 && cd /tmp/discourse && sudo -u discourse bundle install
  27   - exec: chown -R discourse /tmp/discourse
  28   - exec: cd /tmp/discourse && sudo -u discourse bundle exec rake db:migrate
  29   - exec: cd /tmp/discourse && sudo -u discourse RAILS_ENV=test bundle exec rake db:migrate
  30   - exec: rm -fr /tmp/discourse