Installation of PostgreSQL 9.5 Database Server

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

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 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.

Leave a Reply

2 Comment threads
0 Thread replies
Most reacted comment
Hottest comment thread
2 Comment authors
http://Sbobet-bola.comtogel jakarta Recent comment authors
newest oldest most voted
Notify of
togel jakarta

Thanks for sharing your thoughts about ibcbet blackjack.

Hi Dear, are you actually visiting this web page on a regular basis,
if so then you will definitely obtain pleasant knowledge.