Re: pgBackrest Error : authentication method 10 not supported

Thanks for your quick reply.

uname -a
.amzn1.x86_64 #1 SMP Sun Nov 27 06:09:45 UTC 2022 x86_64 x86_64 x86_64
GNU/Linux

Postgres and pgBackrest installed from source

curl -LO
https://github.com/pgbackrest/pgbackrest/archive/release/2.43.tar.gz
wget https://ftp.postgresql.org/pub/source/v14.6/postgresql-14.6.tar.gz

Thanks

On Thu, Feb 2, 2023 at 2:57 PM Magnus Hagander <magnus(at)hagander(dot)net> wrote:

>
>
> 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)
>>>
>>>