Installing the PostgreSQL database server

PostgreSQL is one of the most powerful database management systems, and is publicly available, and free of cost. This open source database management software runs on every platform, including Windows, Linux, and macOS. Using this database management system, you will be able to store and process very large data. The following table will give you an understanding of how large data can be handled using the PostgreSQL database:

Limit	Value
Maximum database size	Unlimited
Maximum table size	32 TB
Maximum row size	1.6 TB
Maximum field size	1 GB
Maximum row per table	Unlimited
Maximum columns per table	250-1,600 depending on column types
Maximum indexes per table	Unlimited

Capacity of PostgreSQL database (source: https://www.postgresql.org/about/)

In this recipe, you will download and install...