scope: postgres-cluster2
namespace: /mydb2/
name: testbed04

log:
  format: '%(asctime)s %(levelname)s: %(message)s'
  level: INFO
  max_queue_size: 1000
  traceback_level: ERROR
  type: plain

restapi:
  connect_address: 10.114.16.33:8008
  listen: 10.114.16.33:8008

etcd3:
  host:
     10.114.16.51:2379

# The bootstrap configuration. Works only when the cluster is not yet initialized.
# If the cluster is already initialized, all changes in the `bootstrap` section are ignored!
bootstrap:
  # This section will be written into <dcs>:/<namespace>/<scope>/config after initializing
  # new cluster and all other cluster members will use it as a `global configuration`.
  # WARNING! If you want to change any of the parameters that were set up
  # via `bootstrap.dcs` section, please use `patronictl edit-config`!
  dcs:
    loop_wait: 10
    retry_timeout: 10
    ttl: 30
    postgresql:
      parameters:
        DateStyle: ISO, MDY
        TimeZone: America/New_York
        cluster_name: ''
        default_text_search_config: pg_catalog.english
        dynamic_shared_memory_type: posix
        hot_standby: 'on'
        lc_messages: en_US.UTF-8
        lc_monetary: en_US.UTF-8
        lc_numeric: en_US.UTF-8
        lc_time: en_US.UTF-8
        log_destination: stderr
        log_directory: log
        log_filename: postgresql-%a.log
        log_line_prefix: '%m [%p] '
        log_rotation_age: 1d
        log_rotation_size: '0'
        log_timezone: America/New_York
        log_truncate_on_rotation: 'on'
        logging_collector: 'on'
        max_connections: '100'
        max_locks_per_transaction: '64'
        max_prepared_transactions: '200'
        max_replication_slots: '10'
        max_wal_senders: '10'
        max_wal_size: 1GB
        max_worker_processes: '8'
        min_wal_size: 80MB
        shared_buffers: 128MB
        shared_preload_libraries: citus
        track_commit_timestamp: 'off'
        wal_keep_size: '0'
        wal_level: replica
        wal_log_hints: 'on'
      use_slots: true
citus:
  group: 0  # 0 for coordinator and 1, 2, 3, etc for workers
  database: ctafiniti  # must be the same on all nodes


postgresql:
  authentication:
    replication:
      password: test
      username: replica_user
    superuser:
      password: test
      username: postgres
  create_replica_methods:
        - basebackup
  basebackup:
        wal-method: 'stream'
        checkpoint: 'fast'
  bin_dir: /usr/pgsql-16/bin
  connect_address: 10.114.16.33:5432
  data_dir: /data/ctdatabase
  listen: 10.114.16.33:5432
  parameters:
    hba_file: /data/ctdatabase/pg_hba.conf
    ident_file: /data/ctdatabase/pg_ident.conf
  pg_hba:
  - local   all             all                                     peer
  - host    all             all             10.0.0.0/8              trust
  - host    all             all             127.0.0.1/32            trust
  - host    all             all             ::1/128                 trust
  - local   replication     all                                     peer
  - host    replication     replica_user         10.114.16.28/32              md5
  - host    replication     replica_user         10.114.16.33/32              md5

tags:
  nofailover: true
  noloadbalance: false
  nostream: false
  nosync: false

loop_wait: 10
maximum_lag_on_failover: 1048576
postgresql:
  parameters:
    archive_command: cp %p /data/archive/%f
    archive_mode: 'on'
    archive_timeout: 1800s
    hot_standby: 'on'
    max_connections: 100
    max_locks_per_transaction: 64
    max_replication_slots: 10
    max_wal_senders: 10
    max_worker_processes: 8
    shared_preload_libraries: citus,pg_cron
    ssl_dh_params_file: /data/ctdatabase/dhparams.pem
    synchronous_commit: 'on'
    synchronous_standby_names: '*'
    unix_socket_directories: /run/postgresql
    wal_keep_size: 16
    wal_level: replica
  use_pg_rewind: true
  use_slots: true
retry_timeout: 10
synchronous_mode: true
ttl: 30