patrimith wrote:
Greetings List!
I'm trying get remote management of postrgesql on Ubuntu 5.10 set up.
I am hoping to set up authentication in pg_hba.conf as
host all all 192.168.0.0/0 md5
but I wasn't successful. When I relaxed it to:
host all all 192.168.0.0/0 password
everything worked fine.
Can someone let me know how to configure pgAdmin so that it sends the
password md5 encrypted?
Thanks,
Patrick Smith
http://www.openengagement.com
I currently talk to a PostgreSQL 8.2.3 server using PgAdmin 1.6.2 with
MD5 encrypted passwords just fine.
What is the value of "password_encryption" in your PostgreSQL server's
postgresql.conf file?
[EMAIL PROTECTED] ~]# cat /endeavour/dbstore/postgresql.conf|grep
'password_encryption'
password_encryption = on
[EMAIL PROTECTED] ~]#
Try setting it to 'on' and restarting your server.
Regards,
Andy.