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/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster