Chapter 31. Enhanced Security

This chapter describes enhanced security mechanisms available in the certified edition of Postgres Pro Standard. Moreover, Postgres Pro Standard provides the following native security tools:

  • The pg_proaudit extension enables detailed logging of various security events.

  • Advanced authentication policies allow you to restrict database usage and enforce password requirements by assigning profiles to roles. For details on profiles, see CREATE PROFILE. The catalog pg_profile lists all profiles available for your cluster.