Introduction

PostgreSQL is a powerful open source relational database management system (DBMS). It features a powerful type system and advanced programming functions. This allows it to store and perform calculations on complex values, such as geographic coordinates, JSON objects, and arrays.

PostgreSQL uses a distributed client-server architecture, which means that the database server and client applications can run on separate machines. If the client and server are running on the same system, they can communicate using Unix sockets; otherwise, they communicate over the network by using TCP sockets. The Postgres server uses port number 5432 by default, but this setting can be changed if needed.

Note

Unix domain sockets are channels used for inter-process communication. Different programs running on the same machine can read and write information to a socket, enabling communication between the programs. Unix sockets are represented as nodes of the filesystem, so you can find a socket by listing...