You've still not said which distribution you've installed on, so it's hard to say. But no distribution installs into /opt/ by default that I'm aware of. My guess if you installed backrest from a different source than wherever you installed your postgres from, and therefor it's using those libraries. Perhaps backrest is using the actual default operating system install, and your postgres is a non-standard one?
//Magnus
On Tue, Jan 31, 2023 at 7:32 PM Magnus Hagander <magnus@hagander.net> wrote:
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.
This sounds like your libpq is too old, and is not related to backrest itself.
Make sure you have libpq of at least version 10 as well, and not just the server. (Exact package name will of course depend on what distribution you're on, which you didn't specify)