multiple Kerberos Server Principals from 1 instance of pgadmin

From: Ivan Novick <inovick(at)pivotal(dot)io>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: multiple Kerberos Server Principals from 1 instance of pgadmin
Date: 2019-08-15 23:16:09
Message-ID: CAPJXddYJyyA5Z-i=Og_3LMOA2+WDp1Cntm_FbgaGxH+BmoKirg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

We have a user that is working with postgres and greenplum and they said
that pgadmin4 only allows one Kerberos Server Principal per pgAdmin
instance because it takes the value of the environment variable
PGKRBSRVNAME. Kerberos Server Principal value is the name of the user
running Greenplum or Postgres database.

The user is trying to connect to multiple databases and they have different
user names in the installation like gpadmin. pgqa pgprod, etc. So they can
not connect to both from one PGADMIN because the environment variable would
need to be reset when starting pgadmin.

Is there a work around or is it possible that PGADMIN4 can be enhanced so
that a field is added for Kerberos Server Principal name into the
connection configuration form. The value of the field could be set to the
connection property krbsrvname.

Proposed change would allow to connect to multiple instance running under
different userids from the same pgAdmin instance.

Thanks for your feedback on the best way to move forward.

Ivan
--
Ivan Novick
Pivotal Greenplum Product Lead
https://www.youtube.com/GreenplumDatabase

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Stephen Frost 2019-08-15 23:54:02 Re: multiple Kerberos Server Principals from 1 instance of pgadmin
Previous Message Ojha Sachchida N [Contractor] 2019-08-15 18:58:28 RE: pgAdmin4 SW (32-bit or 64-bit) on Windows