Understand client-server communication in PostgreSQL

Intermediate
Database Administrator
Azure Database for PostgreSQL

PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you will learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.

Learning objectives

After completing this module, you'll be able to:

  • Understand connection handling.
  • Understand the PostgreSQL client tools.

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.