Skip to content

Instantly share code, notes, and snippets.

@brygom
Last active November 8, 2018 18:41
Show Gist options
  • Select an option

  • Save brygom/9e59e01bb11eb74ebbce641088f91620 to your computer and use it in GitHub Desktop.

Select an option

Save brygom/9e59e01bb11eb74ebbce641088f91620 to your computer and use it in GitHub Desktop.
scope: my-ha-cluster
name: pg-2
restapi:
listen: 0.0.0.0:8008
connect_address: 127.0.0.1:8008
etcd:
host: 127.0.0.1:2379
bootstrap:
dcs:
ttl: 30
loop_wait: 10
retry_timeout: 10
maximum_lag_on_failover: 1048576
postgresql:
use_pg_rewind: true
use_slots: true
parameters:
wal_level: replica
hot_standby: "on"
wal_keep_segments: 8
max_wal_senders: 5
max_replication_slots: 5
checkpoint_timeout: 30
initdb:
- encoding: UTF8
pg_hba:
- host all dba all md5
- host replication repl all md5
users:
dba:
password: secret
options:
- createrole
- createdb
repl:
password: secret
options:
- replication
postgresql:
listen: 0.0.0.0:5432
connect_address: 127.0.0.1:5432
data_dir: /etc/pg/data/
config_dir: /etc/pg/data/
bin_dir: /usr/lib/postgresql/9.6/bin
authentication:
replication:
username: repl
password: secret
superuser:
username: dba
password: secret
parameters:
unix_socket_directories: '/tmp'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment