This article will cover how to install and remove the PostgreSQL server and create a database in PostgreSQL on CentOS 8. Also you will learn how to add tables in the database by using the SQL query.
PostgreSQL is available from CentOS 8's default AppStream software repository, and there are multiple versions which you can install.
You can choose between these versions by enabling the appropriate collection of packages and dependencies that align with the version you want to install, with each collection referred to as a module stream.
To List out the available streams for the postgresql module using the dnf command:
$ dnf module list postgresql