pg_auto_failover issues with password auth

Поиск
Список
Период
Сортировка
От Roland Che
Тема pg_auto_failover issues with password auth
Дата
Msg-id CAKnNPjyPJ+asqr9UBD=b91=4wDCQ7+_+UYhk1ciHzTEYEZrh8Q@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Md. Ezhar Ansari"
Дата:
Сообщение: Re: Inquiry Regarding Automatic Tuning Features in PostgreSQL
Следующее
От: SOzcn
Дата:
Сообщение: Log Rotation