How to setup and configure PostgreSQL 9.4 on Debian 8

In this tutorial we will explain you how to setup and configure PostgreSQL 9.4 on Debian 8 VPS.

WHAT IS POSTGRESQL? PostgreSQL is a robust, open source relational database management system (object-relational DBMS or ORDBMS) based on the Berkeley system.

PostgreSQL includes a powerful object-relational data model, a rich selection of data types, good scalability, as well as an upgraded set of SQL commands. It also supports advanced functions that allow the server to execute blocks of code. Regarding everything functions in PostgreSQL can be written in many programming languages. It is also important to mention that PostgreSQL supports most of the SQL standards.

Installing PostgreSQL on a Debian VPS is pretty easy and straight forward procedure. Just follow the steps in this tutorial and you install PostgreSQL on your VPS very fast.

LET’S START First, you will need to log in to your VPS as ROOT via SSH. Once you are in the first thing you need to do is to downloads the package lists from the repositories and “update” them to get information on the newest versions of packages and their dependencies. It will do this for all repositories and PPAs. To do that just type:

apt-get update The next step/command will actually update all the software on your VPS. So, type:

apt-get upgrade

INSTALLING POSTGRESQL To install PostgreSQL 9.4 on Debian 8 server just type:

apt-get install postgresql-9.4 postgresql-client-9.4 Once the installation is done you can check if the PostgreSQL server up and running with the following command:

ps aux | grep postgre And if everything is ok you will see something as:

Full Story