Skip to main content
Kill -9 Club
Sign in

Roles and pg_hba.conf: why psql gets in and the application is refused

An application role, a read-only backup role, and the file that decides the authentication method line by line.

24 minutesTechnical content last reviewed on 16 Sept 2026

This lesson is for signed-in learners

Create an account to subscribe and record your learning progress.

What this lesson builds

  • Administering PostgreSQL: access, connections and growth
  • Keeping secrets out of the places that publish them