PostgreSQL PGCES-02 Exam - Topic 5 Question 6 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 6
Topic #: 5

psql generated the following error message: psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connections on port 5432? Select two reasons that are NOT the cause of this error.

AHost 'server.example.com' does not exist.

BThe PostgreSQL server is not running on 'server.example.com'.

CThe PostgreSQL server is not accepting TCP/IP connections on 'server.example.com'.

DThe PostgreSQL server is running on a port other than 5432 on 'server.example.com'.

EThe username and/or password are incorrect.

Show Suggested Answer

Suggested Answer: A, E

by Stephane at May 05, 2022, 06:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Eileen

4 months ago

I thought incorrect credentials could cause this too, but maybe not?

upvoted 0 times

...

Oren

4 months ago

C is definitely a reason, but E is unrelated.

upvoted 0 times

...

Walton

4 months ago

Wait, could it actually be D? That’s a possibility!

upvoted 0 times

...

Gaston

4 months ago

I agree, B is also not the cause here.

upvoted 0 times

...

Glendora

4 months ago

Definitely not A, that host exists.

upvoted 0 times

...

Sabrina

5 months ago

I’m a bit confused, but I think option A about the host not existing could be a valid reason for the error, so maybe it’s not one of the answers we need.

upvoted 0 times

...

Selma

5 months ago

I feel like we had a practice question about server ports, so option D could be a reason that doesn't cause the error.

upvoted 0 times

...

Carman

5 months ago

I'm not entirely sure, but I think option E about username and password might not be related to the connection refusal error.

upvoted 0 times

...

Mirta

5 months ago

I remember we discussed that if the server isn't running, it would definitely cause a connection issue, so I think option B is likely a cause.

upvoted 0 times

...

Marnie

5 months ago

Okay, let me think this through. The question says the GVP deployment requires TTS using MRCP, so I need to make sure the MRCP settings are correct. I'll go with option A and update the MRCP URL.

upvoted 0 times

...

Erasmo

5 months ago

Okay, I've got this. PIM is focused on efficient multicast routing, so the answer has to be about something like preventing forwarding loops or ensuring delivery. I'm confident I can get this right.

upvoted 0 times

...

Tommy

5 months ago

I think Application Centric Infrastructure is definitely involved since it optimizes deployment. It feels similar to practice questions we've done.

upvoted 0 times

...