New Year Sale ! 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 10 Question 76 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 76
Topic #: 10
[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 Edward at Oct 19, 2024, 03:08 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Martina
1 months ago
Option G: 'host all all 127.0.0.1/8 md5, host all all 0.0.0.0/0 password=1234'. Security is overrated anyway.
upvoted 0 times
Kimberlie
3 days ago
E) The settings are fine as is.
upvoted 0 times
...
Larae
4 days ago
E) The settings are fine as is.
upvoted 0 times
...
Ardella
6 days ago
C) Add host foo bar 172.16.1.2/32 trust to the last row.
upvoted 0 times
...
Tamala
13 days ago
C) Add host foo bar 172.16.1.2/32 trust to the last row.
upvoted 0 times
...
Leota
19 days ago
A) Add host foo bar 172.16.1.2/32 trust to the first row.
upvoted 0 times
...
Moon
19 days ago
A) Add host foo bar 172.16.1.2/32 trust to the first row.
upvoted 0 times
...
...
Chaya
2 months ago
Option B, all the way! Gotta keep those passwords secure, even if it's a bit of a hassle. Can't be too careful these days, am I right?
upvoted 0 times
...
Raylene
2 months ago
Hmm, I'm not too sure about this one. Maybe option E is the safest bet - the settings seem fine as they are. Why mess with a working configuration, right?
upvoted 0 times
...
Izetta
2 months ago
I'd go with option D. It's clearer to add the 'trust' line for the 'bar' user on the 'foo' database from the specific IP address.
upvoted 0 times
Brittni
19 days ago
Let's go with option D then.
upvoted 0 times
...
Brett
1 months ago
I agree, adding 'trust' for 'bar' on 'foo' from the specific IP makes sense.
upvoted 0 times
...
Carry
1 months ago
I think option D is the best choice.
upvoted 0 times
...
...
Rikki
2 months ago
Option C looks good to me. Adding the 'trust' authentication method for the user 'foo' on the database 'bar' from the specific IP address '172.16.1.2' seems like the right approach.
upvoted 0 times
Sage
1 months ago
User 4: Great, let's go with option C then.
upvoted 0 times
...
Jose
1 months ago
User 3: That makes sense, it's the last row so it won't interfere with other settings.
upvoted 0 times
...
Annabelle
1 months ago
User 2: I agree, adding 'trust' for user 'foo' on database 'bar' from IP '172.16.1.2' is the way to go.
upvoted 0 times
...
Jacki
1 months ago
User 1: Option C looks good to me.
upvoted 0 times
...
...
Ilene
2 months ago
I agree with Merilyn, because adding 'host foo bar 172.16.1.2/32 trust' to the last row would allow password verification to not be performed for user foo connecting from host IP address 172.16.1.2.
upvoted 0 times
...
Merilyn
2 months ago
I think the answer is C.
upvoted 0 times
...

Save Cancel