Tutorial 06-PostgreSQL DB installation/ImplementatIon on RHEL8

Published: 07 April 2020
on channel: mynoteoracledba
1,979
18

Here we are going to see the steps of postgresql12 client and server installation on RHEL 8

For doubts contact us
Mynotesdba@gmail.com

Steps for installtion:

S-1:for RHEL-8 OS rpm

yum install https://download.postgresql.org/pub/r...

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 mynotesdba@gmail.com

#Postgresql12Installation #SoftwareInstallation #PostgresqlDb #Installation #Redhat8


On this page of the site you can watch the video online Tutorial 06-PostgreSQL DB installation/ImplementatIon on RHEL8 with a duration of hours minute second in good quality, which was uploaded by the user mynoteoracledba 07 April 2020, share the link with friends and acquaintances, this video has already been watched 1,979 times on youtube and it was liked by 18 viewers. Enjoy your viewing!