BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL Exam PGCES-02 Topic 1 Question 59 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 59
Topic #: 1
[All PGCES-02 Questions]

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 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.

Show Suggested Answer Hide Answer
Suggested Answer: B

by Twana at Apr 19, 2024, 06:30 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Remedios
6 months ago
What about B? It also mentions trust with the right IP.
upvoted 0 times
...
Barrett
6 months ago
Higher-order lines get processed first. Putting it high ensures no password check.
upvoted 0 times
...
Frederic
6 months ago
Hmm, but why the first row?
upvoted 0 times
...
Barrett
6 months ago
I think the answer should be A. Adding 'host foo bar 172.16.1.2/32 trust' to the first row.
upvoted 0 times
...
Brande
6 months ago
Agreed, the configuration order matters a lot. Any thoughts?
upvoted 0 times
...
Alona
7 months ago
This question is tricky. Understanding pg_hba.conf can be confusing.
upvoted 0 times
...
Barrett
7 months ago
Great, let's make that change then.
upvoted 0 times
...
Chi
7 months ago
Actually, we should add 'host bar foo 7Barrett.6..Barrett/3Barrett trust' to the first row.
upvoted 0 times
...
Barrett
7 months ago
Are you sure that's the correct line?
upvoted 0 times
...
Chi
7 months ago
I believe we should add 'host foo bar 7Barrett.6..Barrett/3Barrett trust' to the first row.
upvoted 0 times
...
Barrett
7 months ago
Do you know which line needs to be changed?
upvoted 0 times
...
Chi
7 months ago
I think we need to modify the pg_hba.conf file.
upvoted 0 times
...

Save Cancel