PostgreSQL - Roles and Security
Which line correctly sets password authentication to SCRAM in the
pg_hba.conf file?Which line correctly sets password authentication to SCRAM in the pg_hba.conf file?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the correct authentication method syntax
Thepg_hba.conffile uses lines like 'host all all address method' to set authentication.Step 2: Match method to SCRAM
To use SCRAM, the method must be exactly 'scram-sha-256'.Final Answer:
host all all 0.0.0.0/0 scram-sha-256 -> Option CQuick Check:
SCRAM method line = host all all 0.0.0.0/0 scram-sha-256 [OK]
Quick Trick: SCRAM method is 'scram-sha-256' exactly in pg_hba.conf [OK]
Common Mistakes:
- Using 'md5' instead of 'scram-sha-256' for SCRAM
- Confusing 'password' with SCRAM
- Omitting the IP address or using wrong format
Master "Roles and Security" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes