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

Melvin

16 hours ago

Easy peasy, it's B! 192.168.1.1 is the only one that's explicitly allowed. Although, I'd love to know who set up this config file - it's like a game of IP Address Twister!

upvoted 0 times

...

Earleen

4 days ago

Oooh, tricky one! Let's see, the 192.168.0.0/16 network is rejected, but 192.168.1.0/24 is allowed. So I'm gonna go with D, 192.168.1.0. Gotta love those subnet masks!

upvoted 0 times

...

Dylan

5 days ago

Hmm, looks like the configuration is a bit of a mess. I'm going to go with B, 192.168.1.1. It's the only one that's explicitly allowed in the 192.168.1.0/24 network.

upvoted 0 times

...