HOME BLOG PORTFOLIO PHOTO CONTACT Admin Login
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

Fatal error: Uncaught mysqli_sql_exception: MySQL server has gone away in /Applications/MAMP/htdocs/bharatbaba.com/classCommon.php:71 Stack trace: #0 /Applications/MAMP/htdocs/bharatbaba.com/classCommon.php(71): mysqli_query(Object(mysqli), 'INSERT INTO ips...') #1 /Applications/MAMP/htdocs/bharatbaba.com/analytics.jay.php(53): common::sql_queryNewVerson('INSERT INTO ips...', Object(mysqli)) #2 /Applications/MAMP/htdocs/bharatbaba.com/footer.php(76): require_once('/Applications/M...') #3 /Applications/MAMP/htdocs/bharatbaba.com/blog.php(120): require_once('/Applications/M...') #4 {main} thrown in /Applications/MAMP/htdocs/bharatbaba.com/classCommon.php on line 71