PostgreSQL Exam PGCES-02 Topic 10 Question 76 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 76
Topic #: 10

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.

AAdd 'host foo bar 172.16.1.2/32 trust' to the first row.

BAdd 'host bar foo 172.16.1.2/32 trust' to the first row.

CAdd 'host foo bar 172.16.1.2/32 trust' to the last row.

DAdd 'host bar foo 172.16.1.2/32 trust' to the last row.

EThe settings are fine as is.

Show Suggested 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

23 days 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

Leota

3 days ago

A) Add host foo bar 172.16.1.2/32 trust to the first row.

upvoted 0 times

...

Moon

3 days ago

A) Add host foo bar 172.16.1.2/32 trust to the first row.

upvoted 0 times

...

Chaya

1 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

1 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

1 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

3 days ago

Let's go with option D then.

upvoted 0 times

...

Brett

18 days ago

I agree, adding 'trust' for 'bar' on 'foo' from the specific IP makes sense.

upvoted 0 times

...

Carry

26 days ago

I think option D is the best choice.

upvoted 0 times

...

Rikki

1 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

19 days ago

User 4: Great, let's go with option C then.

upvoted 0 times

...

Jose

21 days ago

User 3: That makes sense, it's the last row so it won't interfere with other settings.

upvoted 0 times

...

Annabelle

22 days 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

29 days 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

...