Обсуждение: Kerberos with pgAdmin v3

Поиск
Список
Период
Сортировка

Kerberos with pgAdmin v3

От
Amit jain
Дата:
Hi All, 

We need to connect the kerberos postgresql/greenplum instance with the pgAdmin v3 version. I couldn't find any settings in pgAdmin v3 to put kerberos as authentication type and put file location of krb5.conf or and user credentials cache location. 

Any help to get connected with pgAdmin with kerberized Database will be appreciated.

pgAdminv4 - it needs to tweak some browser settings which are blocked in my organisation so I want to give it a try with pgAdmin v3 now.  

Regards,
Amit Jain
9833777592

Re: Kerberos with pgAdmin v3

От
Aditya Toshniwal
Дата:
Hi Amit,

pgAdmin4 desktop latest version does not open in browser anymore. Instead, it has its own container(electron) now.
The mailing list does not support pgAdmin3.

On Mon, Aug 16, 2021 at 7:07 PM Amit jain <amit7.jain@gmail.com> wrote:
Hi All, 

We need to connect the kerberos postgresql/greenplum instance with the pgAdmin v3 version. I couldn't find any settings in pgAdmin v3 to put kerberos as authentication type and put file location of krb5.conf or and user credentials cache location. 

Any help to get connected with pgAdmin with kerberized Database will be appreciated.

pgAdminv4 - it needs to tweak some browser settings which are blocked in my organisation so I want to give it a try with pgAdmin v3 now.  

Regards,
Amit Jain
9833777592


--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: Kerberos with pgAdmin v3

От
Aditya Toshniwal
Дата:
Hi Amit,

Just a correction, the container is NWjs based and not electron based.
I suggest you to try the latest version of pgAdmin4. Please note, there is no active development done on pgAdmin 3.

On Mon, Aug 16, 2021, 22:08 Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Amit,

pgAdmin4 desktop latest version does not open in browser anymore. Instead, it has its own container(electron) now.
The mailing list does not support pgAdmin3.

On Mon, Aug 16, 2021 at 7:07 PM Amit jain <amit7.jain@gmail.com> wrote:
Hi All, 

We need to connect the kerberos postgresql/greenplum instance with the pgAdmin v3 version. I couldn't find any settings in pgAdmin v3 to put kerberos as authentication type and put file location of krb5.conf or and user credentials cache location. 

Any help to get connected with pgAdmin with kerberized Database will be appreciated.

pgAdminv4 - it needs to tweak some browser settings which are blocked in my organisation so I want to give it a try with pgAdmin v3 now.  

Regards,
Amit Jain
9833777592


--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: Kerberos with pgAdmin v3

От
Khushboo Vashi
Дата:
Hi,

On Mon, Aug 16, 2021 at 7:07 PM Amit jain <amit7.jain@gmail.com> wrote:
Hi All, 

We need to connect the kerberos postgresql/greenplum instance with the pgAdmin v3 version. I couldn't find any settings in pgAdmin v3 to put kerberos as authentication type and put file location of krb5.conf or and user credentials cache location. 

Any help to get connected with pgAdmin with kerberized Database will be appreciated.

pgAdminv4 - it needs to tweak some browser settings which are blocked in my organisation so I want to give it a try with pgAdmin v3 now.  


pgAdmin 4 Desktop mode (single user mode) *does not* need any settings to connect the postgresql instance using Kerberos. So, if your setup is ready to use Kerberos to connect PostgreSQL, you can connect the server using Kerberos in pgAdmin 4.
If you want to use server mode (multi user mode), then you need all the settings you mentioned above.

Thanks,
Khushboo

Regards,
Amit Jain
9833777592