Conference Schedule - PGCon 2023

Configuration and Authentication

Date: 2023-05-31
Time: 13:00–13:45
Room: DMS 1140
Level: Intermediate

PostgreSQL relies on three configuration files for authentication, able to handle many options to set up a cluster in an either secured or flexible way when it comes to authentication policies and rules: pg_hba.conf, pg_ident.conf and postgresql.conf.

This talk presents the important things to know about each one of these configuration files, and how they can be used to set up a PostgreSQL instance in a way wanted. This talk provides a coverage of the existing options available, what they do, including a few gotchas that users are not usually aware of.

PostgreSQL 16 is adding support for a lot of new features in this area. These are covered in the last part of the talk.

link to video


The following slides have been made available for this session:


Michael Paquier