PostgreSQL Exam PGCES-02 Topic 3 Question 82 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 82
Topic #: 3

Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust host all all 192.168.1.0/24 reject host all all 192.168.0.0/16 trust Select a host IP address which is authorized to connect to this database via the network. Note:

INET domain socket communication is available.

A127.0.0.1

B192.168.1.1

C192.168.0.1

D192.168.1.0

ENone can be connected.

Show Suggested Answer

Suggested Answer: B

by Daniel at Mar 09, 2025, 11:56 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Fausto

3 hours ago

Hmm, that's a good point. I see where you're coming from. Let's double check the configuration file to be sure.

upvoted 0 times

...

Coral

1 days ago

I disagree, I believe the correct answer is D) 192.168.1.0 because it matches the subnet specified in the configuration file.

upvoted 0 times

...

Fausto

3 days ago

I think the correct answer is B) 192.168.1.1 because it falls within the range specified in the configuration file.

upvoted 0 times

...