We have an application running via a utility that want's clear text passwords stored in it's config files. I know we can setup ident mapping but the app doesn't play nice with password prompt requests. We could set it's connections to trust but it kinda defeats the purpose security wise.
Any thoughts on best/common practices per connecting to postgres securely without an interactive password prompt