Re: looking for a installation package to Using GSSAPI with Postgres12 for windows

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: "LE MENTEC, SANDRINE" <sandrine(dot)le-mentec(at)capgemini(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "KOUMIRA, Adnane" <adnane(dot)koumira(at)capgemini(dot)com>
Subject: Re: looking for a installation package to Using GSSAPI with Postgres12 for windows
Date: 2021-04-13 14:34:31
Message-ID: 20210413163431.1a175537@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

On Tue, 13 Apr 2021 08:10:06 +0000
"LE MENTEC, SANDRINE" <sandrine(dot)le-mentec(at)capgemini(dot)com> wrote:

> Dear postgres community,
>
> I am currently working on Postgres 12.5 on a windows server 2016. I need to
> use Kerberos token for the authentication on the database.
>
> To do so, I am looking for an installation executable file for windows with
> the GSSAPI included. The basic one provided by EDB does not seem to include
> this features.

I had the same problem and fixed it by using sspi.

If you want to authenticate against a microsoft domain, try to replace "gss"
with "sspi", and maybe set "compat_realm=0" if needed. It will try to use
Kerberos, or fallback on NTLM.

See: https://www.postgresql.org/docs/12/sspi-auth.html

Regards,

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-04-13 14:51:44 Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
Previous Message Zhihong Yu 2021-04-13 14:07:52 Re: Have I found an interval arithmetic bug?