forked from cloudfoundry/cf-deployment
-
Notifications
You must be signed in to change notification settings - Fork 0
/
use-community-postgres.yml
95 lines (85 loc) · 3.04 KB
/
use-community-postgres.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
- type: replace
path: /releases/name=postgres
value:
name: community-postgres
version: "3.2.0"
url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.2.0/postgres-3.2.0.tgz
sha1: 470c2b6d98d988ad9dc36dedcd8133e247de63f7
- type: remove
path: /instance_groups/name=database/migrated_from
- type: replace
path: /instance_groups/name=database/instances
value: 1
- type: replace
path: /instance_groups/name=database/jobs
value:
- name: postgres
release: community-postgres
properties:
postgres:
config:
port: 5524
listen_addresses: '*'
max_connections: 100
replication:
enabled: false
hba:
- host all all 0.0.0.0/0 md5
- host all all ::/0 md5
users:
- username: cloud_controller
password: ((cc_database_password))
- username: uaa
password: ((uaa_database_password))
- username: diego
password: ((diego_database_password))
- username: routing-api
password: ((routing_api_database_password))
- username: network_policy
password: ((network_policy_database_password))
- username: network_connectivity
password: ((network_connectivity_database_password))
- username: locket
password: ((locket_database_password))
- username: credhub
password: ((credhub_database_password))
databases:
- name: cloud_controller
users: [cloud_controller]
extensions: [citext, pgcrypto]
- name: uaa
users: [uaa]
extensions: [citext, pgcrypto]
- name: diego
users: [diego]
extensions: [citext, pgcrypto]
- name: routing-api
users: [routing-api]
extensions: [citext, pgcrypto]
- name: network_policy
users: [network_policy]
extensions: [citext, pgcrypto]
- name: network_connectivity
users: [network_connectivity]
extensions: [citext, pgcrypto]
- name: locket
users: [locket]
extensions: [citext, pgcrypto]
- name: credhub
users: [credhub]
extensions: [citext, pgcrypto]
- type: replace
path: /instance_groups/name=uaa/jobs/name=uaa/properties/uaadb/address?
value: sql-db.service.cf.internal
- type: replace
path: /instance_groups/name=api/jobs/name=cloud_controller_ng/properties/ccdb/address?
value: sql-db.service.cf.internal
- type: replace
path: /instance_groups/name=cc-worker/jobs/name=cloud_controller_worker/properties/ccdb/address?
value: sql-db.service.cf.internal
- type: replace
path: /instance_groups/name=scheduler/jobs/name=cloud_controller_clock/properties/ccdb/address?
value: sql-db.service.cf.internal
- type: replace
path: /instance_groups/name=scheduler/jobs/name=cc_deployment_updater/properties/ccdb/address?
value: sql-db.service.cf.internal