I created an internal wiki for our team, and I needed to password-protect the whole thing. I didn't want users to have to authenticate themselves to Apache, then get to the wiki pages and have to log in again, so I went looking for an automated solution. I found info on doing it with MySQL, but not with PostgreSQL.

