Re: PGAdmin Connectivity Issues

Hello Khushboo,

Yes, we are using Kerberos for postgres connections.

Thanks,

Ami Chovatiya

CoStar Group

achovatiya(at)costar(dot)com<mailto: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<mailto: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<mailto:cawe(at)costar(dot)com>