Waiting for PostgreSQL 17 – Add support event triggers on authenticated login

This is an interesting feature that can be used to disallow login after 3 failed attempts, for example.