Patroni HA setup Main PID: 3167 (code=exited, status=217/USER)

234 views Asked by At

Here is a screen shot of patroni.service status: enter image description here

Following is the configuration of my patroni.yml:

scope: pg_cluster
namespace: /service/
name: patroni1

restapi:
    listen: 192.168.56.11:8008
    connect_address: 192.168.56.11:8008

etcd:
    hosts: 192.168.56.11:2379,192.168.56.12:2379,192.168.56.13: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:

  initdb:
  - encoding: UTF8
  - data-checksums

  pg_hba:
  - host replication replicator 127.0.0.1/32 md5
  - host replication replicator 192.168.56.11/0 md5
  - host replication replicator 192.168.56.12/0 md5
  - host replication replicator 192.168.56.13/0 md5
  - host all all 0.0.0.0/0 md5

  users:
    admin:
      password: admin
      options:
        - createrole
        - createdb

postgresql:
  listen: 192.168.56.11:5432
  connect_address: 192.168.56.11:5432
  data_dir: /usr/local/pgsql/data/
  bin_dir: /usr/local/pgsql/bin
  pgpass: /tmp/pgpass
  authentication:
    replication:
      username: replicator
      password: replicator
    superuser:
      username: postgredbenterprise
      password: postgres

watchdog:
  mode: required
  device: /dev/watchdog
  safety_margin: 5

tags:
    nofailover: false
    noloadbalance: false
    clonefrom: false
    nosync: false

I have installed postgres from source.

I have tried changing ownership of data directory and patroni.yml file to no avail. Tried other soultions which I found over internet. But no exact answers for this particular problem.I am new to this. Can someone please tell me why I am getting this error and how to fix it?

0

There are 0 answers