Re: PQconnectdbParams and encrypted password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dmitry Markman <dmarkman(at)mac(dot)com>
Cc: pgsql-interfaces(at)lists(dot)postgresql(dot)org
Subject: Re: PQconnectdbParams and encrypted password
Date: 2019-08-30 13:50:32
Message-ID: 14941.1567173032@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Dmitry Markman <dmarkman(at)mac(dot)com> writes:
> I need some help with setting PQconnectdbParams key/value for encrypted password
> suppose I created user with the string
> create user foobar with encrypted password ‘md5f3c33545d22dbf811737afb8d0e85597’
> ...
> {"password", ??????????????},//I’d like to have here “md5f3c33545d22dbf811737afb8d0e85597”, but it doesn’t work

Pretty much the entire *point* of an encrypted password is that the
md5 hash is not sufficient to log in with. You need the original
string.

regards, tom lane

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dmitry Markman 2019-08-30 22:48:47 Re: PQconnectdbParams and encrypted password
Previous Message Dmitry Markman 2019-08-30 04:19:15 PQconnectdbParams and encrypted password