How To Install PostgreSQL on Centos 7

September 17, 2016

How To Install PostgreSQL on Centos 7

How To Install PostgreSQL on Centos 7

How To Install PostgreSQL on Centos 7? PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

1. First, add PostgreSQL Yum repository to your system.


2. Install PostgreSQL server.


Once the postgresql94-server package is installed, you need to initialize a database:


3. Start PostgreSQL server.


4. Configure Iptables or firewall.

Adjust iptables to access postgresql from remote systems:


5. Create test database and Create new user PostgreSQL.

Once the installation is completed, you can start using the PostgreSQL 9.4 on your CentOS 7 by typing the commands:


Create test database (as postgres user).


Login test database (as postgres user).


Delete database (as postgres user).


Congratulation’s! You have successfully installed PostgreSQL Server.

Save

Save