postgresql_worker.yml.erb

---
<%
service = "postgresql"
plan_enabled = properties.service_plans && properties.service_plans.send(service.to_sym)
plan = properties.plan || "free"
plan_conf = plan_enabled && properties.service_plans.send(service.to_sym).send(plan.to_sym).configuration
lifecycle = properties.service_lifecycle
use_warden = plan_enabled && plan_conf.warden && plan_conf.warden.enable
node = properties.postgresql_node
supported_versions = node.supported_versions

version_configs = {
  '9.0' => {
    'port'        => 5432,
    'binary_dir'  => '/var/vcap/packages/postgresql/bin',
  },

  '9.1' => {
    'port'        => 5433,
    'binary_dir'  => '/var/vcap/packages/postgresql91/bin',
  }
}
%>
<% if lifecycle and lifecycle.resque %>
<% snapshot_dir = lifecycle.mount_point || "/var/vcap/services_snapshot" %>
service_name: postgresql
snapshots_base_dir: <%= snapshot_dir %>
serialization_base_dir: <%= snapshot_dir %>
local_db: sqlite3:/var/vcap/store/postgresql_node.db
tmp_dir: <%= properties.service_lifecycle.tmp_dir || "/tmp" %>
resque:
  host: <%= properties.service_lifecycle.resque.host %>
  port: <%= properties.service_lifecycle.resque.port %>
  password: <%= properties.service_lifecycle.resque.password %>
  expire: <%= properties.service_lifecycle.resque.expire %>
logging:
  level: debug
  file: /var/vcap/sys/log/postgresql_node/postgresql_worker.log
  <% if properties.syslog_aggregator %>
  syslog: vcap.postgresql_worker
  <% end %>
index: <%= spec.index %>
node_id: <%= "#{service}_node_#{plan}_#{spec.index}" %>
download_url_template: "http://<%= lifecycle.download_url %>/serialized/%{service}/%{name}/snapshots/%{snapshot_id}?token=%{token}"
snapshot_quota: <%= plan_enabled && plan_conf.lifecycle && plan_conf.lifecycle.snapshot && plan_conf.lifecycle.snapshot.quota || 0 %>
# optional download tuning
serialization:
  max_download_size_mb: <%= properties.service_lifecycle.serialization_max_download_size || 10 %>
# addtional options
postgresql:
<% for version in supported_versions
     config = version_configs[version]
%>
  '<%= version %>':
   host: 127.0.0.1
   user: vcap
   pass: <%= node.password %>
   port: <%= config['port'] %>
   database: postgres
   dump_bin: <%= "#{config['binary_dir']}/pg_dump" %>
   restore_bin: <%= "#{config['binary_dir']}/pg_restore" %>
<% end %>

<%if use_warden%>
use_warden: true
<%end%>
<% end %>