Installation of PostgreSQL 9.5 Database Server On Redhat/CentOS 7

Installation of PostgreSQL 9.5 Server is an object-relational database management server. It’s an open-source that uses the SQL language combined with many features to store data and scale database workloads.

It uses the Port No 5432

Installation of PostgreSQL 9.5 Database Server:

Features of PostgreSQL 9.5 so

  • Multi-version concurrency control (MVCC) so
  • User-defined type so
  • Big data features so
  • Row-level security policies so
  • BRIN (Block range Indexes) so
  • Foreign table inheritance so

Check Out: Error “ Job For Postgresql.service failed ”

Packages required for Postgresql

  1. postgresql-libs
  2. postgresql
  3. postgresql-server

Installation Begins

You can check what version is available on your machine

Command is yum provides PostgreSQL

See postgresql-9.2.23-3.el7_4.x86_64 is available on my Server Machine.

Step 1: Run below command to install the packages

yum install postgresql-9.2.23-3.el7_4.x86_64* –y

Step 2: Verify by the installed package.

Now initialize the database of PostgreSQL.

The command is postgresql-setup initdb

Check Out: Enable Remote Access To Postgresql 9.5Database Server

Step 2: Check where PostgreSQL data files are stored. so

Command is ls /var/lib/pgsql/data/

Step 3: Now start the service and enable at boot time. so

systemctl start postgresql

systemctl enable postgresql

Check status

Step 4: login PostgreSQL Server

Commands are su – postgres

Then access the PostgreSQL database by psql

Step 5: Check database available by \l

Now you have successfully PostgreSQL installed and tested. so

You’re done.

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

2 thoughts on “Installation of PostgreSQL 9.5 Database Server On Redhat/CentOS 7”

Leave a comment