Hello,
I am getting an error message " authentication method 10 not supported" while trying to create stanza on postgres14 after upgrading postgres from v.10 to Postgres v.14.
I am using pgbackrest version: v.43 and the scram-sha-256 for hba authentication.
pgbackrest.conf entry:
cat /etc/pgbackrest/pgbackrest.conf
[global]
repo1-path=/opt/backups
repo1-retention-full=2
[test14]
pg1-path=/opt/PostgreSQL-14/data
pg1-port=5432
pg1-user=postgres
pg1-socket-path=/tmp
Error Message:
pgbackrest stanza-create --stanza=test14 --log-level-console=info --log-path=/etc/pgbackrest/log
2023-01-31 08:46:37.683 P00 INFO: stanza-create command begin 2.43: --exec-id=15887-3e1eecf6 --log-level-console=info --log-path=/etc/pgbackrest/log --pg1-path=/opt/PostgreSQL-14/data --pg1-port=5432 --pg1-socket-path=/tmp --pg1-user=postgres --repo1-path=/opt/backups --stanza=test14
WARN: unable to check pg1: [DbConnectError] unable to connect to 'dbname='postgres' port=5432 user='postgres' host='/tmp'': authentication method 10 not supported
ERROR: [056]: unable to find primary cluster - cannot proceed
HINT: are all available clusters in recovery?
2023-01-31 08:46:37.686 P00 INFO: stanza-create command end: aborted with exception [056]
[root@ip-172-31-43-98 ~]#