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.

2
Leave a Reply

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

Thanks for sharing your thoughts about ibcbet blackjack.
Regards

http://Sbobet-bola.com
Guest

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