[pgpool-general: 4009] Re: Import MD5 password hashes

[Joshua D. Drake]

On 08/25/2015 07:41 PM, James Sewell wrote:
> Hey All,
>
> Is there any plan to support either MD5 hash import or active MD5
> checking from PostgreSQL like PGBouncer now supports?
>
> So I suppose either a way of periodically updating pool_password from
> pg_shadow, or have an admin connection which is used to dynamically
> query pg_shadow for each login?
>
> If there isn't any plan in the near future I might write a trigger based
> solution which can be added - would there be any interest in this?

I just use a cron that runs the query and writes it to the file.

JD

-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.