Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> writes:
> And so on. Regular Unix users have their passwords set from the NIS
> passwd database (standard crypt method), and PostgreSQL-specific users
> have their passwords defined in pg_shadow (no encryption there). This
> last use prevents us from using PAM-style authentication I presume.
I don't see why. You could write a PAM plugin to do whatever you want
(that's the whole point of PAM, isn't it)?
regards, tom lane