PostgreSQL is developed by PostgreSQL Global Development Group. PostgreSQL is a general purpose free and open-source object-relational database management system, the most advanced open source database system. You are allow to add custom functions developed using different programming languages such as C/C++, Java, etc.
PostgreSQL is designed to run other various platforms like Mac OS X, Solaris, Windows and Unix-like platform. In PostgreSQL you can define your own data types, index types, functional languages etc. PostgreSQL implemented multi-version concurrency control (MVCC) feature even before Oracle. In Oracle MVCC feature is known as snapshot isolation. In this article, we will go through the steps involved to install PostgreSQL in RedHat & CentOS 8 Linux.
Some of the features which are highlighted below due to which PostgreSQL stands out.
Step 1: Postgresql provide DNF Repository.
Execute below command from console to download and install PostgreSQL
For RedHat, CentOS, Scientific or Oracle Linux Version 8
# dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# dnf -qy module disable postgresql
Step 2: Install PostgreSQL server and client.
# dnf install postgresql12-server postgresql12
Step 3: Initialize the PostgreSQL database once the installation is done.
# /usr/pgsql-12/bin/postgresql-12-setup initdb
Step 4: Start the PostgreSQL service and enable it to start on reboot the system and check the status of the service is running
# systemctl enable postgresql-12
# systemctl start postgresql-12
# systemctl status postgresql-12
Step 5: PostgreSQL by default runs on port 5432, check the listening port with below command.
# netstat -antp | grep 5432
Step 6: postgres user is created during the installation of PostgreSQL with blank password. You need to switch user (su) postgres to login into PostgreSQL database. Use psql utility to login into database as shown in below pic.
Step 7: Set password for user postgres to Secure login.
# passwd postgres
All the config files are found at /var/lib/pgsql/12/data directory.
That’s it. In this post we have seen the installation of PostgreSQL in RedHat & CentOS 8 Linux. Please share your experience with us through comment box below.
