Re: pgBackrest Error : authentication method 10 not supported - Mailing list pgsql-general

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

On Thu, Feb 2, 2023 at 2:57 PM Magnus Hagander <magnus@hagander.net> wrote:

On Thu, Feb 2, 2023 at 7:46 AM Daulat <daulat.dba@gmail.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@hagander.net> wrote:

On Tue, Jan 31, 2023 at 2:58 PM Daulat <daulat.dba@gmail.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)