How To Install PostgreSQL on CentOS 6




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

Step 2. Install PostgreSQL server.

To install a basic PostgreSQL 9.4 server use the following command:

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

Step 3. Start PostgreSQL.

Step 4. Create test database and Create new user PostgreSQL.

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

Create test database (as postgres user).

Login test database (as postgres user).

Congratulation’s! You have successfully installed PostgreSQL Server. Thanks for using this tutorial for installing PostgreSQL on CentOS 6 systems.

VPS Manage Service Offer