Follow the instructions in the /usr/local/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.