Postgresql Installation

PostgreSQL is an open source object-relational, highly scalable, SQL-compliant database management system. PostgreSQL is developed at the University of California at Berkeley Computer Science Department. This article will help you for installing PostgreSQL 9.6 on CentOS 7 , RHEL and Linux Machine.

1. Go to your db Server

2. Download Postgresql yum repositories

3. Install Postgres Server

4. Enable Postgres Service

5. After installing PostgreSQL server, It’s required to initialize it before using the first time. To initialize database use below command.

Above command will take some time to initialize PostgreSQL first time. PGDATA environment variable contains the path of data directory.

6. Start the Postgres

7. Give the permission/authentication to Postgres for accessing to the client.

8. Start PostgreSQL Server

To start PostgreSQL service using the following command as per your operating systems. Also, enable PostgreSQL service to auto start on system boot.

9. Verifying PostgreSQL Installation

Congratulation’s! You have successfully installed PostgreSQL Server. Read below article to install phpPgAdmin.

Post Author: Rohit

4 thoughts on “Postgresql Installation

    mytech

    (May 4, 2017 - 11:38 am)

    Please visit once !! And give your valuable points.

    satya

    (May 4, 2017 - 11:51 am)

    How to import & Export in Postgres.

    Neha

    (August 31, 2017 - 8:53 am)

    Thanks !! for this Blog..its really helpful and nice way to communicate.

    Chetan Kapoor

    (August 31, 2017 - 2:26 pm)

    Thanks!!

Leave a Reply

Your email address will not be published. Required fields are marked *