×

This article covers PostgreSQL 13 installation on Rocky Linux 8.4. Basically, PostgreSQL is the world's most advanced open source database system. And with the release of PostgreSQL 13 there are significant improvements to the indexing and lookup system that benefit large databases, and faster response times for queries that use aggregates or partitions.


How to Enable and Start PostgreSQL Service ?

To enable and start the PostgreSQL database service so that it can start automatically with system boot:

$ sudo systemctl start postgresql-13
$ sudo systemctl enable postgresql-13

To confirm everything is working fine, check the status of PostgreSQL service:

$ sudo systemctl status postgresql-13



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




More Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com