RE: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

Thank you very much for your reply.
However, after installing PostgreSQL 16.4, our server still encounters the following error when connecting to the database, just like with version 16.3:
“Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10”.
Could you please advise how to resolve this error? Should we also update Npgsql? If Npgsql needs to be updated, to which version should we update it?
Looking forward to your response.

-----Original Message-----
From: Daniel Gustafsson <daniel(at)yesql(dot)se>
Sent: Friday, October 25, 2024 7:58 PM
To: 馬　騰飛 <ma-tengfei(at)nec(dot)cn>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

CAUTION：This is an external email. Please be cautious when opening links or attachments in email.

> On 25 Oct 2024, at 05:45, 馬　騰飛 <ma-tengfei(at)nec(dot)cn> wrote:
>
> Dear PostgreSQL Community,
>
> After upgrading PostgreSQL to version 16.3, our server encountered the
> error "Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10" when connecting to the database.
>
> We are currently using .NET Framework version 3.5. If we upgrade Npgsql to version 8.0.5, will there be compatibility issues?
> If there are compatibility issues, could you tell me the minimum version of Npgsql that we should use to upgrade PostgreSQL to 16.3 without upgrading the .NET Framework?

Try PostgreSQL 16.4 instead, there was a known regression for very old Npgsql versions in 16.3.

--
Daniel Gustafsson