patroni-workshop/postgres.yml at main · isaias-sanchez-utiq/patroni-workshop · GitHub

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
scope: demo
namespace: /patroni/
name: postgresql

log:
  dir: /var/log/postgresql/
  mode: 0644
  file_num: 7
  traceback_level: INFO
  level: INFO

consul:
  host: consul:8500
  scheme: http
  verify: false
  register_service: true

restapi:
  listen: 0.0.0.0:8008
  connect_address: 0.0.0.0:8008

bootstrap:
  method: initdb
  dcs:
    ttl: 30
    loop_wait: 10
    retry_timeout: 10
    maximum_lag_on_failover: 1048576
    check_timeline: true
    failsafe_mode: false
    postgresql:
      use_pg_rewind: true
      remove_data_directory_on_rewind_failure: true
      remove_data_directory_on_diverged_timelines: true
      use_slots: true
      parameters:
        max_connections: '256'
        max_worker_processes: '20'
        wal_level: 'logical'
        logging_collector: 'on'
        log_directory: '/var/log/postgresql/'
        log_filename: 'postgresql.log'
        log_file_mode: '0644'
        log_min_messages: 'notice'
        log_min_duration_statement: '100'
        log_checkpoints: 'on'
        log_connections: 'on'
        log_disconnections: 'on'
        log_line_prefix: '%m [%p] [dbname=%d,user=%u,host=%h,app=%a] '
        log_lock_waits: 'on'
        log_recovery_conflict_waits: 'on'
        log_temp_files: '1MB'
        log_timezone: 'UTC'
        track_io_timing: 'on'
        track_wal_io_timing: 'on'
        shared_preload_libraries: 'pg_stat_statements'
        pg_stat_statements.max: '10000'
        pg_stat_statements.save: 'on'
        pg_stat_statements.track_utility: 'on'
        pg_stat_statements.track: 'top'
      pg_hba:
        - host    replication     replicator      0.0.0.0/0              trust
        - host    all             rewind_user     0.0.0.0/0              reject
        - host    all             all             0.0.0.0/0              trust
  initdb:
    - data-checksums
postgresql:
  listen: 0.0.0.0:5432
  connect_address: 0.0.0.0:5432
  data_dir: /var/lib/postgresql/data
  pgpass: /tmp/pgpass0
  authentication:
    replication:
      username: replicator
      password: rep-pass
    superuser:
      username: postgres
      password: postgres
    rewind:
      username: rewind_user
      password: rewind_password
tags: