Tutorial 06-PostgreSQL DB installation/ImplementatIon on RHEL8

Here we are going to see the steps of postgresql12 client and server installation on RHEL 8 For doubts contact us [email protected] Steps for installtion: S-1:for RHEL-8 OS rpm yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm S-2:to list DB installation packages yum list postgresql S-3:To list and disable the postgres APPstream Module yum module list postgresql yum module disable postgresql S-4:To install A postgresql12 client s/w yum install postgresql12 S-5:To install Postgresql12 server yum install postgresql12-server S-6: To initialize the DB instance /usr/pgsql-12/bin/postgresql-12-setup initdb S-7:Enbale the configuration for next autoservice up systemctl enable postgresql-12 S-8:To Start the postgresql service systemctl start postgresql S-9: To check the status postgresql service status service postgresql-12 status S-10:swicth to postgres user su postgres s-11: connect the DB through psql psql S12: check the version select * from version(); S-13: To list the DB in postgres \l S-14: To start and stop service pg_ctl -D $PGDATA stop -mf pg_ctl -D $PGDATA start S-15:to check services status in os level ps -ef|grep postgres subscribe to our channel: https://rebrand.ly/8z3l1y1 For doubts and queries kindly contact us on [email protected] #Postgresql12Installation #SoftwareInstallation #PostgresqlDb #Installation #Redhat8