PostgreSQL Windows ODBC Datasource Administrator Authentication using Kerberos

Hello All,

My team has recently been shifted to using (MIT) Kerberos for authentication to our PostgreSQL database. We are able to successfully authenticate in dBeaver Lite, however we are not able to authenticate in ODBC   We have tried to establish a connection using 32 bit and 64 bit ODBC Data Sources. We have tried using the following psqlodbc driver versions (16.00.0000, 13.01.0000, 09.06.0500).

Across all attempts we have used the following configurations;

POSTGRES/<username>@<REALM> * SSL mode = require *

• we have also tried with postgres/<username>@<REALM> and postgres/<username>@<realm> and <username> and POSTGRES/<username> and postgres/<username> ** we have tried the above also with all of the following SSL modes; (disable, allow, prefer, verify-ca, verify-full)

We have also added the Datasource Connection Settings (with all permutations of casing):

[PostgreSQL] AuthenticationMethod=4 servicePrincipalName=<username>@<realm>/@REALM

The connection using SSL mode = require which we believe is the correct configuration returns the following error;

"connection to server at <server path> port 5432 failed: FATAL: password authentication failed for user POSTGRES/<username>@<REALM>" <- this message is repeated twice.

removing POSTGRES/ returns the same error, but only a single instance of the error. Removing the Datasource Connection Settings and passing <username>@<REALM> returns the following error:

"connection to server at <server path> port 5432 failed: SSPI continuation error: The specified target is unknown or unreachable"