Postgres Server Architecture

Postgres Architecture :
PostgreSQL is a powerful open-source relational database management system with a flexible and extensible architecture.
PostgreSQL follows a client-server model where multiple client programs can connect to a PostgreSQL database server to perform various operations like querying, updating, and managing data.

Overview of PostgreSQL's architecture :
Client-Server Model :
PostgreSQL follows a client-server model. Multiple client applications can connect to a PostgreSQL server to interact with the database. Default port number is 5432.
pg These are programs or interfaces that interact with the PostgreSQL server. Examples include command-line tools like psql, graphical user interface (GUI) tools like pgAdmin, and application programming interfaces (APIs) like psycopg2 for Python or JDBC for Java.

PostgreSQL Server Process :
The PostgreSQL server process, often referred to as the PostgreSQL backend, manages all database operations. When a client connects to the server, a new server process is created to handle that connection. Each server process runs independently and manages its connection to the client.


(Postgres - Server process and Client process ; Postgres program : Internal Process)