Re: PQconnectdbParams and encrypted password - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: PQconnectdbParams and encrypted password
Date
Msg-id 14941.1567173032@sss.pgh.pa.us
Whole thread Raw
In response to PQconnectdbParams and encrypted password  (Dmitry Markman <dmarkman@mac.com>)
Responses Re: PQconnectdbParams and encrypted password
List pgsql-interfaces
Dmitry Markman <dmarkman@mac.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’twork 

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



pgsql-interfaces by date:

Previous
From: Dmitry Markman
Date:
Subject: PQconnectdbParams and encrypted password
Next
From: Dmitry Markman
Date:
Subject: Re: PQconnectdbParams and encrypted password