Choose Your Background

Senin, 28 November 2016

How to Install PostgreSQL, PgAdmin III, and phpPgAdmin on Ubuntu 16.04 [Xenial Xerus]


hello everyone, i want to explain how to install postgresql, pgadmin III, and phppgadmin on ubuntu 16.04. before i install, i want to makesure what is already installed on ubuntu 16.04.  


1. makesure what is postgresql already installed on ubuntu 16.04 with terminal.
A. open terminal on ubuntu with CTRL + ALT + T.
B. type sudo su and enter the password.
C. after login as root on terminal, type "psql --version".
if postgresql is currently not installed, terminal will give feedback  "The program 'psql' is currently not installed. You can install it by typing: apt install postgresql-client-common"
2. install postgresql ubuntu 16.04 with terminal.

A. open terminal on ubuntu with CTRL + ALT + T
B. login as root or super user on Terminal
C. after login as root or super user on terminal, i type "sudo apt-get install postgresql".
D. Terminal will be give feedback about the operation, so i type Y or Yes.
 E. How to check, what if postgresql aldready installed type "psql --version"

3. install pgadmin III on ubuntu 16.04 with terminal.
A. open terminal on ubuntu with CTRL + ALT + T
B. login as root or super user on Terminal
C. after login as root or super user on terminal, i type "sudo apt-get install postgresql".

4. install phpgadmin on ubuntu 16.04 with terminal.
A. open terminal on ubuntu with CTRL + ALT + T
B. login as root or super user on Terminal
C. after login as root or super user on terminal, i type "sudo apt-get install phpgadmin".