Re: Does psycopg2 support Kerberos for Postgres?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Yang Gao <Yang(dot)Gao(at)twosigma(dot)com>, "'psycopg(at)postgresql(dot)org'" <psycopg(at)postgresql(dot)org>
Subject: Re: Does psycopg2 support Kerberos for Postgres?
Date: 2016-12-06 15:32:20
Message-ID: 9a0f6493-5c71-b133-0cbc-a05bfe06b69f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On 12/06/2016 07:20 AM, Yang Gao wrote:
> You are most likely correct about local log in.
>
> This is the string that I'm using:
> sqlalchemy.create_engine("postgresql+psycopg2://fqdn_of_host/db_name")
> I tried adding "? krbsrvname=postgres" at the end as well, but got the error aforementioned.

It would have been nice to know you where using SQLAlchemy above
psycopg2 at the beginning of this conversation.

So again can you show the actual complete string you are using?

Not sure if this a cut and paste error but you have:

? krbsrvname=postgres

Pretty sure the space between ? and krbsrvname is not good.

Also what happens if you bypass SQLAlchemy and try to connect using
psycopg2 directly?

>
> Thanks.
>
> Yang
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Yang Gao 2016-12-06 15:41:31 Re: Does psycopg2 support Kerberos for Postgres?
Previous Message Yang Gao 2016-12-06 15:20:18 Re: Does psycopg2 support Kerberos for Postgres?