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

Slides

The following slides have been made available for this session:

Speaker

Michael Paquier