Re: pg_hba.conf - md5 - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: pg_hba.conf - md5
Date
Msg-id 466ACA4D.5040908@commandprompt.com
Whole thread Raw
In response to pg_hba.conf - md5  (Vince <vincej@gmail.com>)
List pgsql-general
Vince wrote:
> I want to access by postgre db over the internet.  My pg_hba.conf if
> setup to do this:
> host    all         all         0.0.0.0/0    md5
>
> Now, what I don't understand is how does the "md5" effect things?
>
> If I connect via php:
> $db = pg_connect('host=xx.xx.xx.xx port=5433 dbname=MYDB user=postgres
> password=mypass');
>
> "mypass" being whatever my password is; is still set in plain text?

No the resultant md5 hash is.

> Why don't I have to send the md5 version of the password to connect?
>

THe driver does it.

Joshua D. Drake


> Thanks,
> Vince.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-general by date:

Previous
From: Andreas
Date:
Subject: odbc with encrypted ssl key?
Next
From: "hubert depesz lubaczewski"
Date:
Subject: Re: insane index scan times