What Is PostgreSQL?

In today’s article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.

PostgreSQL is a database management system that uses the relational model for databases and supports the SQL standard query language.

PostgreSQL is also a good performing, secure and comprehensive DBMS. We can run it on almost any UNIX or Unix derivative (such as Linux, FreeBSD) operating systems. We can also run it on all Windows systems with NT cores. Of course it is free and open source.

Why PostgreSQL?

PostgreSQL can run on almost any UNIX variant (with the latest stable 34). (True multi-platform support)

It is designed for high volume transactions.

It can easily run on multiple processors.

Since it is not a commercial database, it gives importance to security rather than speed.

PostgreSQL Architecture

Above you can see the schematic of a PostgreSQL application:

Here you can see many clients connecting to the server in a network environment. For PostgreSQL, it must be a TCP/IP network – local area network or internet.

Each client connects to a master database server process (represented here as postmaster), which creates a new server process to specifically service access requests from that client.

PostgreSQL’s client-server architecture helps divide the workforce. We can use a server machine organized to hold and access large amounts of data as a secure data store.

Advanced graphical applications can be developed for clients. Alternatively, web-based applications can also handle your client-side operations.

The server side of PostgreSQL consists of a UNIX “deamon” named postmaster and several UNIX processes called backends.

The postmaster provides coordination between backends and communication between backends and clients. A separate backend job runs for each client.

I hope it will be useful for you. See you in my other articles.