PostgreSQL DBA tips Live (Postgresql dba tutorial)

if you like my videos you can follow me Zulqarnain Hayat and sub me on you tube

Hit like on my Facebook Page

Hit like on my twitter Page

[TeacherCom]

Thanks for it's Wonderful information ℹ️

[ZulqarnainHayat]

Objective: PostgreSQL Installation from Source code


3 major:

1) Procuring an EC2 RHEL8 Instance

2) Downloading PostgreSQL 11.5 source code

3) Configure & setup postgresql database server.



1) Procuring an EC2 RHEL8 instance:

Start a new EC2 instance
Login to EC2 instance from putty

Swith to root and then
Install required packages
dnf install readline-devel
dnf install zlib-devel
dnf install gcc
dnf install make

mkdir -p



2) Download source code

www.postgresql.org => downloads => Source code => File browser => 11.5
winscp .gz file to RHEL EC2 VM

gunzip postgresql-11.5.tar.gz
tar -xvf postgresql-11.5.tar


3) Configure & Setup


./configure --with-pgport=5432
make <= To start the build
make install <= This will install PostgreSQl into the directory specified in ./configure step
useradd -d /home/postgres/ postgres
passwd postgres
mkdir -p
chown postgres

su - postgres
-D
-D

vi .bash_profile
export
export