PostgreSQL PGCES-02 Exam - 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

Olen

4 months ago

Wait, can 127.0.0.1 connect too?

upvoted 0 times

...

Joanna

4 months ago

I think 192.168.0.1 is actually rejected.

upvoted 0 times

...

Dyan

4 months ago

192.168.1.1 is good to go!

upvoted 0 times

...

Glendora

4 months ago

Definitely not 192.168.0.1, that's a no.

upvoted 0 times

...

Afton

4 months ago

Seems like none can connect, right?

upvoted 0 times

...

Christoper

5 months ago

I feel like none can connect since the reject rule is pretty strict, but I might be overthinking it.

upvoted 0 times

...

Fletcher

5 months ago

I'm confused about 192.168.0.1 because it seems like it should be rejected based on the config.

upvoted 0 times

...

Melina

5 months ago

I remember something about the "trust" method allowing connections, so maybe 192.168.1.1 is the right choice.

upvoted 0 times

...

Melvin

5 months ago

I think 192.168.1.1 should be allowed since it's in the 192.168.1.0/24 range, but I'm not completely sure.

upvoted 0 times

...

Shenika

5 months ago

This is a tricky one. I'm going to sketch out the IP address ranges on paper to visualize the network configuration and make sure I select the right answer.

upvoted 0 times

...

Carla

6 months ago

Wait, what about the local all all trust line? Doesn't that mean the localhost address 127.0.0.1 should also be allowed? I'm not sure, but I'll double-check my understanding before answering.

upvoted 0 times

...

Wayne

6 months ago

Okay, I think I've got this. The 192.168.1.0/24 range is allowed, but the 192.168.0.0/16 range is rejected. So the authorized IP address must be within the 192.168.1.0/24 range, which means 192.168.1.1 is the correct answer.

upvoted 0 times

...

Ayesha

6 months ago

Hmm, I'm a bit confused by the subnet mask notation. I'll need to review my networking concepts to make sure I understand how to interpret the 192.168.0.0/16 and 192.168.1.0/24 ranges.

upvoted 0 times

...

Della

6 months ago

This looks like a straightforward networking question. I'll carefully read through the configuration file details and think through the IP address ranges to determine which one is authorized.

upvoted 0 times

...

Ciara

11 months ago

Ah, the joys of network security! I'm gonna go with B, 192.168.1.1. It's the only one that's explicitly allowed, and I'm not feeling lucky enough to try any of the others. Although, I do have a strong urge to change that config file...just for fun, of course!

upvoted 0 times

Ivette

9 months ago

User 4: Yeah, changing the config file just for fun might not end well!

upvoted 0 times

...

Lauran

10 months ago

User 3: I agree, it's always best to stick to what's explicitly allowed.

upvoted 0 times

...

Misty

10 months ago

User 2: Good choice, better safe than sorry!

upvoted 0 times

...

Elenor

10 months ago

User 1: B) 192.168.1.1

upvoted 0 times

...

Jesusa

11 months ago

Hmm, I'm feeling a bit like a hacker trying to break into Fort Knox here. But I think the answer is B, 192.168.1.1. I mean, who doesn't love a good ol' network security challenge, right? *winks*

upvoted 0 times

Denae

10 months ago

User 3: Agreed, let's go with 192.168.1.1.

upvoted 0 times

...

Bernadine

11 months ago

User 2: Yeah, that seems like the right choice.

upvoted 0 times

...

Glenna

11 months ago

User 1: I think the answer is B, 192.168.1.1.

upvoted 0 times

...

Melvin

12 months 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

Tamar

10 months ago

I wonder why they chose such specific IP addresses to allow or reject.

upvoted 0 times

...

Eleni

10 months ago

True, it's a bit of a puzzle with all those different settings.

upvoted 0 times

...

Ruth

10 months ago

Easy peasy, it's B! 192.168.1.1 is the only one that's explicitly allowed.

upvoted 0 times

...

Rosenda

10 months ago

E) None can be connected.

upvoted 0 times

...

Veronika

10 months ago

D) 192.168.1.0

upvoted 0 times

...

Salome

10 months ago

C) 192.168.0.1

upvoted 0 times

...

Eun

10 months ago

B) 192.168.1.1

upvoted 0 times

...

Jules

11 months ago

A) 127.0.0.1

upvoted 0 times

...

Earleen

12 months 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

12 months 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

...