Follow the instructions in the %%PREFIX%%/share/doc/pam-pgsql/README to use this module. Note, that unlike most other ports, this port installs a file into /usr/lib directly (/usr/lib/pam_pgsql.so), because PAM requires that.