patrimith wrote: <blockquote cite="mid8992548.post@talk.nabble.com" type="cite"><pre wrap="">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
<a class="moz-txt-link-freetext" href="http://www.openengagement.com">http://www.openengagement.com</a>
</pre></blockquote><font size="-1"><font face="Arial"><br /> I currently talk to a PostgreSQL 8.2.3 server using
PgAdmin1.6.2 with MD5 encrypted passwords just fine.<br /> What is the value of "password_encryption" in your
PostgreSQLserver's postgresql.conf file?<br /><br /> [root@byron ~]# cat /endeavour/dbstore/postgresql.conf|grep
'password_encryption'<br/> password_encryption = on<br /> [root@byron ~]#<br /><br /> Try setting it to 'on' and
restartingyour server.<br /><br /> Regards,<br /><br /> Andy.<br /></font></font>
