PostgreSQL_CE
PGCES-02 · Question #69
A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all 172.16.1.0/24 md5 PostgreSQL CE PGCES-02 Exam When user foo connects to database bar from host…
The correct answer is B. Add "host barfoo 172.16.1.2/32 trust" to the first row. See the full explanation below for the reasoning.
Question
A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all 172.16.1.0/24 md5 PostgreSQL CE PGCES-02 Exam When user foo connects to database bar from host IP address 172.16.1.2, I would like password verification to not be performed. Select one appropriate line for the new pg_hba.conf file.
Options
- AAdd "hostfoo bar 172.16.1.2/32 trust" to the first row.
- BAdd "host barfoo 172.16.1.2/32 trust" to the first row.
- CAdd "hostfoo bar 172.16.1.2/32 trust" to the last row.
- DAdd "host barfoo 172.16.1.2/32 trust" to the last row.
- EThe settings are fine as is.
How the community answered
(56 responses)- A4% (2)
- B84% (47)
- C2% (1)
- D2% (1)
- E9% (5)
Community Discussion
No community discussion yet for this question.