Re: pgBackrest Error : authentication method 10 not supported

On Thu, Feb 2, 2023 at 7:46 AM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:

> I have pgbackrest v.43 installed on the same server where we are
> running postgres v14.6 that is upgraded from postgres v.10.2
>
> ls /opt/PostgreSQL-14/lib/
>
> libecpg.a libecpg_compat.so.3.14 libpgcommon.a
> libpgport_shlib.a libpgtypes.so.3.14 libpq.so.5.14
> libecpg_compat.a libecpg.so libpgcommon_shlib.a
> libpgtypes.a libpq.a pkgconfig
> libecpg_compat.so libecpg.so.6 libpgfeutils.a
> libpgtypes.so libpq.so postgresql
> libecpg_compat.so.3 libecpg.so.6.14 libpgport.a
> libpgtypes.so.3 libpq.so.5
>

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(at)hagander(dot)net>
> wrote:
>
>>
>>
>> On Tue, Jan 31, 2023 at 2:58 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:
>>
>>> 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.
>>>
>>
>> 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)
>>
>>