ceesco53

---
name: jmeter-tornado

releases:
- name: jmeter-tornado
  version: 2.1.1
  url: git+https://github.com/jamlo/jmeter-bosh-release

stemcells:
- alias: default

ceesco53

WITH constants AS (
  SELECT current_setting('block_size')::numeric AS bs, 23 AS hdr, 4 AS ma
), bloat_info AS (
  SELECT
    ma,bs,schemaname,tablename,
    (datawidth+(hdr+ma-(case when hdr%ma=0 THEN ma ELSE hdr%ma END)))::numeric AS datahdr,
    (maxfracsum*(nullhdr+ma-(case when nullhdr%ma=0 THEN ma ELSE nullhdr%ma END))) AS nullhdr2
  FROM (
    SELECT
      schemaname, tablename, hdr, ma, bs,

ceesco53

{
    "client_id": "sso-temp-cf-client",
    "client_secret": "'${CF_CLI_CLIENT_SECRET}'",
    "authorized_grant_types": ["client_credentials"],
    "authorities": ["cloud_controller.admin"],
    "access_token_validity": 1209600,
    "refresh_token_validity": 1209600
}


ceesco53

# from Concourse DB VM:
# /var/vcap/packages/postgres-9.6.8/bin/psql -U vcap -d atc
# \l

# backup
cd /var/vcap/packages/postgres-9.6.8/bin
./pg_dump -U vcap -d atc --format=c --schema-only --file=concourse-schema.sql
./pg_dump -U vcap -d atc --format=c --data-only --file=concourse-data.sql

# restore

ceesco53

# crashd log analysis

# I0802 01:01:28.711691       1 server.go:618] external host was not specified, using 10.252.43.236
(?<severity>.{1})%{MONTHNUM:month}%{MONTHDAY:day}%{SPACE}%{TIME:time}%{SPACE}%{NUMBER:number}%{SPACE}(?<filename>\b\w+\.?\w*):%{NUMBER:linenum}]%{SPACE}%{GREEDYDATA:message}

ceesco53

curl -XPOST -D- 'http://localhost:5601/api/saved_objects/index-pattern' \
    -H 'Content-Type: application/json' \
    -H 'kbn-version: 7.14.0' \
    -u elastic:<changeme> \
    -d '{"attributes":{"title":"logstash-*","timeFieldName":"@timestamp"}}'

ceesco53

addons:
- jobs:
  - name: bpm
    release: bpm
  name: bpm
instance_groups:
- azs:
  - az1
  instances: 1
  jobs: