[pgpool-general: 1396] Re: Authentication: pool_hba.conf:md5 & pg_hba.conf:ident = trust ?

[Tatsuo Ishii]

> Could someone help explain how this authentication works on pgpool-II 3.2.1?  I have pgpool's pool_hba.conf configured to use md5 for all connections, while postgres's pg_hba.conf requires ident access.  The behavior I would have expected was that it would prompt for password by pgpool.  To my surprise, I was able to connect to the database without any password prompt at all.

If you want to use md5 auth, you need to use md5 auth both between
client and pgpool-II *and* pgpool-II and PostgreSQL. You cannot mix up
md5 and ident.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp