local   all             all                                     trust

host   all             all              127.0.0.1/            trust

# IPv4 local connections:

host    all             all             10.1.0.0/             md5

# IPv6 local connections:

host    all             all             ::/                 md5

# Allow replication connections from localhost, by a user with the

# replication privilege.

local   replication     all                                     trust

host   replication      all             127.0.0.1/             trust

host    replication     all             10.1.0.0/             md5

host    replication     all             ::/                 trust

cat /etc/patroni/patroni_postgresql.yml

scope: pgha    #集群名

namespace: /pgsql/　　＃etcd path

name: pg_node1  # node 名称　每个节点不同

restapi:

  listen: 10.1.88.82:

  connect_address: 10.1.88.82:

etcd:

  hosts: 10.1.88.81:,10.1.88.82:,10.1.88.83:

  #host: ip:port  #single etd server

bootstrap:

  # this section will be written into Etcd:/<namespace>/<scope>/config after initializing new cluster

  # and all other cluster members will use it as a `global configuration`

  dcs:

    ttl:

    loop_wait:

    retry_timeout:

    maximum_lag_on_failover:

    master_start_timeout:

#    synchronous_mode: false

    postgresql:

      use_pg_rewind: true

      use_slots: false

      parameters:

        listen_addresses: "*"

        port:

        wal_level: logical

        hot_standby: "on"

        wal_keep_segments:

        max_wal_senders:

        #synchronous_standby_names: '*'

        max_connections:

        max_replication_slots:

        wal_log_hints: "on"

postgresql:

  listen: 0.0.0.0:

  connect_address: 10.1.88.82: # local ip

  data_dir: /var/lib/pgsql//data

  bin_dir: /usr/pgsql-/bin

#  config_dir:

  authentication:

    replication:

      username: replicator

      password: replicator

    superuser:

      username: postgres

      password: postgres

#watchdog:

#  mode: automatic # Allowed values: off, automatic, required

#  device: /dev/watchdog

#  safety_margin: 

tags:

    nofailover: false

    noloadbalance: false

    clonefrom: false

    nosync: false

cat /usr/lib/systemd/system/patroni.service

[Unit]

Description=Patroni server

Documentation='https://github.com/zalando/patroni,https://www.opsdash.com/blog/postgres-getting-started-patroni.html'

After=syslog.target

After=network.target

[Service]

Type=simple

User=postgres

Group=postgres

# StandardOutput=syslog

WorkingDirectory=/etc/patroni/

ExecStart=/usr/local/bin/patroni /etc/patroni/patroni_postgresql.yml

ExecReload=/bin/kill -HUP $MAINPID

KillMode=mixed

KillSignal=SIGINT

# Do not set any timeout value, so that systemd will not kill postmaster

# during crash recovery.

TimeoutSec=

[Install]

WantedBy=multi-user.target