1.3.5. Customize and initialize PostgreSQL database

1-      Postgresql-serve Install:
          yum install postgresql-server

2-      Initialize the database:
postgresql-setup initdb

3-      Check the startup and operation of the database by: 
                systemctl start postgresql.service
                systemctl status postgresql.service

4-      Create a new Unix password for postgres

5-       Create a new Unix password for PostgreSQL

6-      PostgreSQL Exit

7-      Create the database siiprod_db

8-     Check database creation at PostgreSQL

9-      Grant fuseadmin privileges on the siiprod_db database

10- Set the following connection options in the PostgreSQL configuration

11-      Edit (root) the PostgreSQL Client Authentication Configuration

12-     Start the postgresql service with:
systemctl restart postgresql.service
systemctl status postgresql.service

13-      Enable postgresql service

14- Install pgAdmin (management platform for PostgreSQL)