PostgreSQL Opensource Installation in RHEL or Oracle Linux(OEL) 8 and above

 Types OF Installation

• Binary(Packages)
• Source
• RPM (Red hat Package Management)
  

Notes: Once Installed the PostgreSQL set Password for postgres (OS Level) User.

Login the root user and set password like passwd postgres

Binary Installation: (Online Installation – Internet Must)

Step 1: goto https://www.postgresql.org/ and click Download Choose Packages on Top Left Cornor
Step 2: Select Your Operating System. Choose Linux and select your Linux distribution(Redhat/centos). and scroll down
Step 3: Select PostgreSQL Version. Example Choose 17
Step 4: Select Linux Platform. Example select Red Hat enterprise, CentOS, Scientific or Oracle version 8
Step 5: Select OS architecture Type. Example Select x86_64
 

 

Step 6: Copy the Script and paste your terminal
Example:

# Install the repository RPM:

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:(Avoid the Old Version)

sudo dnf -qy module disable postgresql

# Install PostgreSQL:

sudo dnf install -y postgresql17-server

# Optionally initialize the database and enable automatic start:

sudo /usr/pgsql-17/bin/postgresql-17-setup initdb
sudo systemctl enable postgresql-17
sudo systemctl start postgresql-17

Source Installation: (Offline Installation)

Step 1: go to https://www.postgresql.org/ and click Download Choose Source on Top Left Corner
Step 2: Click PostgreSQL Version. Example click  v17.3
Step 3: choose tar.gz format file. Example:  postgresql-17.3.tar.gz

 

Step 4: Untar the postgresql-17.3.tar.gz file
Example:
tar -xvzf postgresql-17.3.tar.gz

 Step 5: Open Untar Directory.

Example:
cd postgresql-17.3/

 Step 6:

./configure or ./configure --prefix=/opt/PostgreSQL
options:
–prefix=PREFIX install architecture-independent files in PREFIX [/usr/local/pgsql]

 Step 7:

make && make install

 Step 8: Create data Directory next Change owner & permission

Example:
mkdir /data
chown -R postgres:postgres /data
chmod 700 /data

 Step 9: Installation the database Cluster

Example:
su - postgres
cd /usr/local/pgsql/bin/ ##your prefix path/bin/
./initdb -D /data

Step 10: Start the server
su - postgres
cd /usr/local/pgsql/bin/
./pg_ctl -D /data start

RPM Installation:

Step 1: go to https://yum.postgresql.org/rpmchart/ next Scroll Down Select PostgreSQL version and Choose OS Version with architecture Type.

Example: go to PostgreSQL 17 version and click RHEL / Rocky / Alma Linux 8 - x86_64

 

Step 3: click download Client, Server, Library and Contrib Packages

Example:

postgresql17-17.3-1PGDG.rhel8.x86_64.rpm – PostgreSQL client programs and libraries

postgresql17-contrib-17.3-1PGDG.rhel8.x86_64.rpm – Contributed source and binaries distributed with PostgreSQL

postgresql17-libs-17.3-1PGDG.rhel8.x86_64.rpm  – The shared libraries required for any PostgreSQL clients

postgresql17-server-17.3-1PGDG.rhel8.x86_64.rpm  – The programs needed to create and run a PostgreSQL server

Step 4: Install RPM Packages

Example:
rpm -ivh postgresql17-17.3-1PGDG.rhel8.x86_64.rpm
rpm -ivh postgresql17-contrib-17.3-1PGDG.rhel8.x86_64.rpm
rpm -ivh postgresql17-libs-17.3-1PGDG.rhel8.x86_64.rpm
rpm -ivh postgresql17-server-17.3-1PGDG.rhel8.x86_64.rpm


OR

rpm -ivh postgresql17*.rpm

OR

yum install postgresql17*.rpm

Step 5: Create data Directory next Change owner & permission
Example:
mkdir /rpm_data
chown -R postgres:postgres /rpm_data
chmod 700 /rpm_data

Step 6: Installation the database Cluster

Example:
su - postgres
cd /usr/pgsql-17/bin/ ##your prefix path/bin/
./initdb -D /rpm_data 

Step 7: Start the server

su - postgres
cd /usr/pgsql-17/bin/
./pg_ctl -D /rpm_data start

OR


/usr/pgsql-17/bin/pg_ctl -D /rpm_data start