Verify your knowledge
- What is the aim of the
pg_hba.conffile?The
pg_hba.conffile configures Host-Based-Access (HBA), a set of rules that define how a specific role (either a user or a group) can establish a connection to a specific database from a specific host or source, via a defined protocol. See the Managing incoming connections at the role level section for more details.
- How can you inspect the currently loaded HBA rules?
The special catalog
pg_hba_file_rulesprovides details about loaded rules. See the Inspecting pg_hba.conf rules section for more details.
- Does the order of rules within
pg_hba.confmatter?Yes, the rules are evaluated from top to bottom, and the first matching rule causes the end of the evaluation. See the Order of rules in pg_hba.conf section for more details.
- Where can you find information about roles?
The special catalogs
pg_rolesandpg_authidprovide information about roles....
