Re: How to debug authentication issues in Postgres

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to debug authentication issues in Postgres
Date: 2020-11-29 11:08:17
Message-ID: CA+mi_8avwXgPaWtPoUW=cu794R5hhJ8S+7u28ALasROtii-W-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

IIRC you need libpq at least 10 to use password encryption other than md5.
Maybe your java client uses an older version, or no libpq at all and the
client library misses that feature?

-- Daniele

On Sat, 28 Nov 2020, 16:12 Hemil Ruparel, <hemilruparel2002(at)gmail(dot)com>
wrote:

> I am unable to connect using Java in general. And DataGrip runs on Java as
> far as I know. My backend in python runs perfectly fine using the psycopg2
> library (postgres driver for python).
>
> I was actually changing the database name and user name
>
> On Sat, Nov 28, 2020 at 9:28 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 11/28/20 6:10 AM, Hemil Ruparel wrote:
>> > Line 88 is this line: host database user 0.0.0.0/0
>> > <http://0.0.0.0/0> scram-sha-256.
>> >
>> > I might have forgotten to change one of the names in the earlier mails.
>> >
>>
>> Change from what? This should just be a copy and paste or am I missing
>> something?
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-11-29 16:22:51 Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4
Previous Message Hemil Ruparel 2020-11-29 05:42:03 Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4