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