This step should have been completed upon the installation of Drupal 8 for getting PHPMailer function

Install Composer

# curl -sS https://getcomposer.org/installer | php

Move Composer binary to usr bin path

# mv composer.phar /usr/bin/composer

Check Composer Version

# composer --version

Go to Drupal root Directory and execute

Drupal Installation Directory - /var/www/html

This step should have been completed upon the installation of PostgreSQL, but if you haven’t, you can complete it with:

Install Repository

yum -y install https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Now you are ready to install pgAdmin with:

Install Dependencies

MBR Backup

[root@testsvr01~]#  dd if=/dev/sda1 of=/opt/mbr_backup bs=512 count=1

0+1 records in
0+1 records out
115 bytes (115 B) copied, 0.0001912 s, 601 kB/s

[root@testsvr01~]#

[root@testsvr01 ~]# cat << EOF > /etc/ssh/sshd-banner #############################################################################

         ACCESS WARNING: THIS IS Learns to Win NETWORK
         *********************************************************

  Unauthorized access to this device or the attached networks is prohibited
  without express written permission. Violators will be prosecuted to the
  fullest extend of both civil and criminal law.

• Check Available Disk

[root@testsvr01~]# lsblk
NAME                  MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda                     8:0    0  100G  0 disk
sdb                     8:16   0  500G  0 disk
sdc                     8:32   0  500G  0 disk
└─vg_pgdata-lv_pgdata 253:2    0  500G  0 lvm  /pgdata
sr0                    11:0    1 1024M  0 rom
vda                   252:0    0  100G  0 disk
├─vda1                252:1    0  500M  0 part /boot
└─vda2                252:2    0 99.5G  0 part

• Check Available Disk

[root@testsvr01~]# lsblk
NAME          MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda             8:0    0   60G  0 disk
├─sda1          8:1    0    1G  0 part /boot
└─sda2          8:2    0   59G  0 part
  ├─rhel-root 253:0    0 35.6G  0 lvm  /
  ├─rhel-swap 253:1    0    6G  0 lvm  [SWAP]
  └─rhel-home 253:2    0 17.4G  0 lvm  /home
sdb             8:16   0  250G  0 disk
sdc             8:32   0  250G  0 disk

See the below Query to find Unused index in PostgreSQL

[root@testsvr01~]# useradd sysadmin -G wheel

[root@testsvr01~]# passwd sysadmin
Changing password for user sysadmin.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
[root@testsvr01~]#

[root@testsvr01~]# rpm -q kernel
kernel-3.10.0-1160.15.2.el7.x86_64
kernel-3.10.0-1160.21.1.el7.x86_64
kernel-3.10.0-1160.24.1.el7.x86_64
kernel-3.10.0-1160.36.2.el7.x86_64
kernel-3.10.0-1160.71.1.el7.x86_64
[root@ehapp01 ~]# package-cleanup --oldkernels --count=1
Loaded plugins: fastestmirror, langpacks
--> Running transaction check
---> Package kernel.x86_64 0:3.10.0-1160.15.2.el7 will be erased
---> Package kernel.x86_64 0:3.10.0-1160.21.1.el7 will be erased

[root@testsvr01~]# df -Th | grep "^/dev"
/dev/mapper/rhel-root xfs        50G  8.8G   42G  18% /
/dev/vda1             xfs       497M  199M  299M  40% /boot
/dev/mapper/rhel-home xfs        46G  8.9G   37G  20% /home
[root@testsvr01~]#