PostgreSQL is one of the most advanced and widely used open-source databases that is growing in popularity every year. While it is a relational database similar to Oracle, MySQL, or SQL Server databases, its JSON features make it stand out from some of the most widely used NoSQL databases. While it makes PostgreSQL unique in the database world, several of its techniques work slightly differently from those of other relational databases, such as MVCC implementation.
In this chapter, we shall start by learning how to install PostgreSQL 13 and initializing a data directory. We will then discuss pg_ctl and how it can be used to start and stop a PostgreSQL cluster.
We will then move on to discussing various shutdown modes available in PostgreSQL. After getting familiar with start and shutdown, we will discuss all the directories, sub-directories, and...
