Linux PAM authentication function. Obviously, this kind of thing presumes you trust the server. The service file name is y_pg_pamc. I have only tested this against Linux PAM.
The Makefile implements the standard PostgreSQL PGXS build infrastructure. Run 'make' and 'make install' with appropriate permissions to build and install y_pg_pam.so. Execute the SQL calls in y_pg_pam.sql to instantiate the functions within your database.
% select y_pam_auth( 'username', 'wrongpass' ); y_pam_auth ------------ f (1 row) % select y_pam_auth( 'username', 'rightpass' ); y_pam_auth ------------ t (1 row)
Please send comments and suggestions to 'ron dot peterson at yellowbank dot com'.
More Yellowbank Code.