PostgreSQL 10+ SCRAM-SHA-256 Authentication

[ljwilson]

Starting with PostgreSQL 10, SCRAM-SHA-256 authentication was introduced.
As of PostgreSQL 13, SCRAM-SHA-256 is the default (instead of MD5).

As of InDE 21.0 r13, the .NET library used for c# apps to communicate with PostgreSQL is Npgsql.dll Version 3.2.6. This version does NOT support SCRAM-SHA-256.

Fortunately, the next version 3.2.7 does:
SASL/SCRAM-SHA-256 support for PostgreSQL 10 #1530
https://github.com/npgsql/npgsql/issues/1530

List of PostgreSQL drivers which support SCRAM-SHA-256:
https://wiki.postgresql.org/wiki/List_o ... rs#Drivers

For now I put the 3.2.7 Npgsql.dll in my custom\bin directory and reference it in FileList.txt, but it would be nice if InDe could include it (or a later version) instead.

I'll submit an improvement suggestion and reference this post.

In the meantime if anyone needs the file, you can download it from:
https://github.com/npgsql/npgsql/releases/tag/v3.2.7

Thanks...jack

[lucabaldini]

Perfect! We'll fix it in the next InDE version.

Thanks! :-)))))))

[ljwilson]

Excellent--thank you!

...jack

[lucabaldini]

L'attività NPQ05147 è stata completata e sarà disponibile nella versione Instant Developer 21.5. Clicca qui per leggere le note di rilascio.

[ljwilson]

Wonderful--thank you!

...jack