On Mon, Sep 20, 2010 at 6:23 PM, Tatsuo Ishii <[email protected]> wrote:
> I have used PostgreSQL 9.0 + pgpool-II 3.0 and they work fine with md5 > auth. Your log seems to indicate that the password in pool_passwd and > the one in pg_shadow are not identical. Can you verify that? > The query result: > > select passwd from pg_shadow where usename = 'test'; > > must be identical the password in pool_passwd for user test. Ah, that was it! I'll double check how I'm generating the passwords in pool_passwd, but once I copied the md5 from pg_shadow to pool_passwd it started working. Many thanks for your help! Bryan
