MENU
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.
Suggested Answer: B
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
37 comments · newest first
OL
Olen
10 months ago
Wait, can 127.0.0.1 connect too?
JO
Joanna
10 months ago
I think 192.168.0.1 is actually rejected.
DY
Dyan
10 months ago
192.168.1.1 is good to go!
GL
Glendora
10 months ago
Definitely not 192.168.0.1, that's a no.
AF
Afton
10 months ago
Seems like none can connect, right?
CH
Christoper
11 months ago
I feel like none can connect since the reject rule is pretty strict, but I might be overthinking it.
FL
Fletcher
11 months ago
I'm confused about 192.168.0.1 because it seems like it should be rejected based on the config.
ME
Melina
11 months ago
I remember something about the "trust" method allowing connections, so maybe 192.168.1.1 is the right choice.
ME
Melvin
11 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.
SH
Shenika
12 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.
CA
Carla
12 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.
WA
Wayne
12 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.
AY
Ayesha
1 year 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.
DE
Della
1 year 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.
CI
Ciara
1 year 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!
IV
Ivette
1 year ago
User 4: Yeah, changing the config file just for fun might not end well!
LA
Lauran
1 year ago
User 3: I agree, it's always best to stick to what's explicitly allowed.
MI
Misty
1 year ago
User 2: Good choice, better safe than sorry!
EL
Elenor
1 year ago
User 1: B) 192.168.1.1
JE
Jesusa
1 year 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*
DE
Denae
1 year ago
User 3: Agreed, let's go with 192.168.1.1.
BE
Bernadine
1 year ago
User 2: Yeah, that seems like the right choice.
GL
Glenna
1 year ago
User 1: I think the answer is B, 192.168.1.1.
ME
Melvin
1 year 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!
TA
Tamar
1 year ago
I wonder why they chose such specific IP addresses to allow or reject.
EL
Eleni
1 year ago
True, it's a bit of a puzzle with all those different settings.
RU
Ruth
1 year ago
Easy peasy, it's B! 192.168.1.1 is the only one that's explicitly allowed.
RO
Rosenda
1 year ago
E) None can be connected.
VE
Veronika
1 year ago
D) 192.168.1.0
SA
Salome
1 year ago
C) 192.168.0.1
EU
Eun
1 year ago
B) 192.168.1.1
JU
Jules
1 year ago
A) 127.0.0.1
EA
Earleen
1 year 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!
DY
Dylan
1 year 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.
FA
Fausto
2 years ago
Hmm, that's a good point. I see where you're coming from. Let's double check the configuration file to be sure.
CO
Coral
2 years ago
I disagree, I believe the correct answer is D) 192.168.1.0 because it matches the subnet specified in the configuration file.
FA
Fausto
2 years ago
I think the correct answer is B) 192.168.1.1 because it falls within the range specified in the configuration file.