PostgreSQL Exam PGCES-02 Topic 1 Question 59 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 59
Topic #: 1

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 Twana at Apr 19, 2024, 06:30 PM

Limited Time Offer

25%

7 days ago

I think we need to modify the pg_hba.conf file.

upvoted 0 times

...