Wading Into PostgreSQL Authentication
Details
Abstract: An overview of the different ways to authenticate connections built into PostgreSQL. PostgreSQL has a robust authentication system with multiple ways to authenticate connections, which is great, but it's also rather confusing when compared to a DBMS with a much more narrow scope. "Wading Into PostgreSQL authentication" summarizes the different authentication mechanisms available with commentary and notes based on experimentation.
Bio: Ryan Quinn is not a DBA. He's a systems guy with a deep commitment to hooking everything to a central authorization system. He works at the Oklahoma Innovation Institute (OII) in Tulsa, OK as a Systems Engineer on the Tandy Community Supercomputer during the day, and moonlights as the owner of PSI-GREEN.NET, a technology consulting and services firm.