For the first one:
$ yum search mod_auth_pgsql
======================================================== N/S Matched: mod_auth_pgsql =========================================================
mod_auth_pgsql.i686 : Basic authentication for the Apache HTTP Server using a PostgreSQL database
The ssl-cert package is a Debian shell script wrapping openssl to make things easier, or something like that. I don't believe there's an equivalent. On the other hand, it's just a shell script plus some config files. You should be able to just grab that, and, in the worst case, figure out how to run openssl with the right options.
Also, if you're just generated SSL certs to use with Postgres, you can look for explicit instructions on using openssl. For example:
http://www.howtoforge.com/postgresql-ssl-certificates