pg_auto_failover issues with password auth - Mailing list pgsql-admin

From Roland Che
Subject pg_auto_failover issues with password auth
Date
Msg-id CAKnNPjyPJ+asqr9UBD=b91=4wDCQ7+_+UYhk1ciHzTEYEZrh8Q@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello All 
to setup pg_auto_failover using password auth option but having so much issues as standby will
not create properly and on the error massage its bringing up, it will through out the auth scram-sha-256.
and the monitor will set the standby node i am adding as catching up but if i use trust auth, everything
will work well. Any suggestions on how to intergrate use of password with pg_auto_failover?

pg_autoctl show state
  Name |  Node |           Host:Port |        TLI: LSN |   Connection |      Reported State |      Assigned State
-------+-------+---------------------+-----------------+--------------+---------------------+--------------------
node_1 |     1 | primary_ip:5432     |   1: 0/28000148 | read-write ! |        wait_primary |        wait_primary
node_2 |     2 | standby_ip:5432     |          1: 0/0 |       none ! |        wait_standby |          catchingup

PRIMARY CONFIG FILE

[pg_autoctl]
role = keeper
monitor = postgres://autoctl_node:progress@monitor_ip:5432/pg_auto_failover
formation = default
group = 0
name = node_1
hostname = primary_ip
nodekind = standalone

[postgresql]
pgdata = /var/lib/postgresql/14/main/primary
pg_ctl = /usr/lib/postgresql/14/bin/pg_ctl
username = postgres
dbname = postgres
port = 5432
proxyport = 0
listen_addresses = *
auth_method = scram-sha-256
hba_level = minimal

[ssl]
active = 1
sslmode = require
cert_file = /var/lib/postgresql/14/main/primary/server.crt
key_file = /var/lib/postgresql/14/main/primary/server.key

[replication]
maximum_backup_rate = 100M
backup_directory = /var/lib/postgresql/14/main/backup/node_1
password = postgres

[timeout]
network_partition_timeout = 20
prepare_promotion_catchup = 30
prepare_promotion_walreceiver = 5
postgresql_restart_failure_timeout = 20
postgresql_restart_failure_max_retries = 3
listen_notifications_timeout = 0
citus_master_update_node_lock_cooldown = 0
citus_coordinator_wait_max_retries = 0
citus_coordinator_wait_timeout = 0

[citus]
role = primary


MONITOR CONFIG FILE

[pg_autoctl]
role = monitor
hostname = monitor_ip

[postgresql]
pgdata = /var/lib/postgresql/14/main/monitor
pg_ctl = /usr/lib/postgresql/14/bin/pg_ctl
username = autoctl_node
dbname = pg_auto_failover
port = 5432
listen_addresses = *
auth_method = scram-sha-256

[ssl]
sslmode = require
active = 1
cert_file = /var/lib/postgresql/14/main/monitor/server.crt
key_file = /var/lib/postgresql/14/main/monitor/server.key

I will appreciate your ideas
Regards

pgsql-admin by date:

Previous
From: "Md. Ezhar Ansari"
Date:
Subject: Re: Inquiry Regarding Automatic Tuning Features in PostgreSQL
Next
From: SOzcn
Date:
Subject: Log Rotation