Re: pg_hba.conf - md5

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/