on.md

• In gocd repo

./scripts/jump

• target concourse bosh

bosh target 10.0.52.6

• ssh to the db machine

bosh ssh db/0 --default_password p

• become vcap

sudo su vcap # pass is 'p'

• edit the postgres conf

vi /var/vcap/store/postgresql/postgresql.conf

• add a line log_statement = all

• save :wq

• clear logs, restart the server, watch the logs

rm /var/vcap/sys/log/postgresql/postgresql.log
/var/vcap/packages/postgresql_9.3/bin/pg_ctl restart -D /var/vcap/store/postgresql -m fast
tail -f /var/vcap/sys/log/postgresql/postgresql.log

To 'disable' remove the log_statement line