Step Install and Configure PostgreSQL on Linux

PostgreSQL also called Postgres is a powerful and open-source object-relational database system. It is an enterprise-level database having features such as write-ahead logging for fault tolerance, asynchronous replication, Multi-Version Concurrency Control (MVCC), online/hot backups, point-in-time recovery, query planner/optimizer, tablespaces, nested transactions (savepoints), etc.

Postgres’s latest version 15.2 was released on 9 February 2023 by the PostgreSQL global development group.

Following step are follow for the PostgreSQL installation on Linux “Red Hat Enterprise Linux Server release 7.6 (Maipo)”

Step1 -  Download the required PostgreSQL software from the this link        https://www.postgresql.org/download/linux/redhat/

To use the PostgreSQL Yum Repository, follow these steps:

Step 2 : 

Post-installation

Due to policies for Red Hat family distributions, the PostgreSQL installation will not be enabled for automatic start or have the database initialized automatically. To make your database installation complete, you need to perform the following steps, based on your distribution:

   postgresql-setup --initdb

   systemctl enable postgresql.service

   systemctl start postgresql.service

Validate the Installation :

 

Thank you to All ....

Thank you for giving your valuable time to read the above information.