PG SQL INSTALL in UBUNTU

Close your eyes for few seconds, now open your eyes.

STEP1:  use this command in terminal of ubuntu

sudo apt-get install phppgadmin

STEP2: In browser write this url
 http://localhost/phppgadmin
till you can't able to login.

source: https://help.ubuntu.com/community/phpPgAdmin

STEP3: 
 sudo apt-get install postgresql-client

STEP4:

 sudo apt-get install postgresql

STEP5:
sudo apt-get install pgadmin3
STEP6:
password postgres

PUT password and new password as = root
source: https://help.ubuntu.com/community/PostgreSQL

STEP7:
on terminal
gksudo nautilus
source: http://ubuntuforums.org/showthread.php?t=1699393

STEP8:

open this file in editor
/etc/phppgadmin/config.inc.php
and search
$conf['extra_login_security'] = true
make it 

$conf['extra_login_security'] =false

restart your apache [sudo /etc/init.d/apache2 restart]
source
https://help.ubuntu.com/10.04/serverguide/postgresql.html
http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/1760507

now http://localhost/phppgadmin/

Username= postgres

Password=root

Now you can able to login

Cheers...

 For running pgsql from terminal

sudo -u postgres psql postgres
 

   Share on Facebook