Which port and protocol is commonly used by PostgreSQL databases?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $24.99Unlock all

Study for the CPSA Port Numbers Exam. Practice with flashcards and multiple choice questions, each with hints and explanations. Get ready for your test!

Multiple Choice

Which port and protocol is commonly used by PostgreSQL databases?

Explanation:
PostgreSQL uses TCP for client-server communication, providing reliable, ordered delivery of data. The default port it listens on is 5432, which is what clients connect to unless the server is configured to use another port. The other options map to different services—445 is for Windows file sharing (SMB), 27017 is the MongoDB default, and 1521 is Oracle’s listener—so they aren’t correct for PostgreSQL. Therefore, 5432 TCP is the standard choice for PostgreSQL.

PostgreSQL uses TCP for client-server communication, providing reliable, ordered delivery of data. The default port it listens on is 5432, which is what clients connect to unless the server is configured to use another port. The other options map to different services—445 is for Windows file sharing (SMB), 27017 is the MongoDB default, and 1521 is Oracle’s listener—so they aren’t correct for PostgreSQL. Therefore, 5432 TCP is the standard choice for PostgreSQL.

More Multiple Choice Questions
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy