PostgreSQL Exam PGCES-02 Topic 8 Question 70 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 70
Topic #: 8

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 Juan at Sep 11, 2024, 02:43 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Youlanda

2 months ago

I can't help but notice that the error message mentions 'host' and 'port', but not 'username' or 'password'. Guess the devs are so focused on their server setup, they forgot the most important part - logging in! Classic PostgreSQL moment.

upvoted 0 times

...

Janna

2 months ago

I'm pretty sure the answer is B and D. The server's probably down, and the port is definitely wrong. It's like trying to call your grandma on a rotary phone - not gonna work, buddy.

upvoted 0 times

...

Rosamond

2 months ago

B and C seem like the obvious choices. If the server's not running or not accepting connections, there's no way you're getting that sweet, sweet PostgreSQL data. It's like trying to fill up your car with water - not gonna happen.

upvoted 0 times