Re: PGAdmin Connectivity Issues

Hello,

It looks like it has something to do with your Kerberos user login issue;
it's not a pgAdmin issue. The error suggests an ExtraSids misconfiguration,
which is part of the Kerberos validation info structure.
Refer:
https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-pac/69e86ccc-85e3-41b9-b514-7d969cd0ed73

Thanks,
Khushboo

On Wed, Mar 26, 2025 at 5:07 PM Ami Chovatiya <achovatiya(at)costar(dot)com> wrote:

> Hello Khushboo,
>
> Yes, we are using Kerberos for postgres connections.
>
> Thanks,
>
> *Ami Chovatiya*
>
> CoStar Group
>
> achovatiya(at)costar(dot)com <cawe(at)costar(dot)com>
> ------------------------------
> *From:* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* Wednesday, March 26, 2025 6:00 AM
> *To:* Ami Chovatiya <achovatiya(at)costar(dot)com>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)org <
> pgadmin-support(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: PGAdmin Connectivity Issues
>
> EXTERNAL EMAIL
> Hi,
>
> On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <achovatiya(at)costar(dot)com>
> wrote:
>
> Hello,
>
> I hope this email finds you well!
>
> We have a few engineers using pgadmin for postgres access, and they are
> running into the error below.
>
> *Connection failed: connection to server at "100.64.1.5", port 5432
> failed: FATAL: KERB_VALIDATION_INFO::UserFlags has USER_FLAGS_EXTRA_SIDS
> set, but there are no ExtraSids.*
>
> Are you using Kerberos for Postgres connection?
>
>
> Please note that this error is only getting thrown for two users at the
> moment; everyone else can connect. From a system's perspective, all
> permissions align for the users that have access.
>
> Would you be able to share what causes this error to get generated and
> what the solution is?
>
> Thanks,
>
> *Ami Chovatiya*
>
> CoStar Group
>
> achovatiya(at)costar(dot)com <cawe(at)costar(dot)com>
>
>