Install Postgresql , phpPgAdmin and pgadmin on Ubuntu 8.04 Hardy Heron

An article by Silver Moon    4 Comments

Postgresql , phpPGAdmin and pgadmin 3 can be installed from synaptic.

$ sudo apt-get install postgresql phppgadmin pgadmin3

After installation the postgres password of postgresql can be changed like this :

ALTER USER postgres WITH ENCRYPTED PASSWORD ‘<***password***>‘;
To exit :
\q

Also create a database :

$ sudo -u postgres createdb mydb

Now to access localhost/phppgadmin a link needs to be created which points to /usr/share/phppgadmin :

$ ln -s /usr/share/phppgadmin /var/www/phppgadmin

Now localhost/phppgadmin should open up

Trying to login with user : postgres and password : created above might give the error :

Login disallowed for security reasons.
To fix this edit /usr/share/phppgadmin/conf/config.inc.php

and change :

$conf['extra_login_security'] = true;
to
$conf['extra_login_security'] = false;

and then login again from phppgadmin and it should work fine.

Alternatively pgadmin3 can also be used to work with postgresql.

Start pgadmin and create a new connection using the icon on top left and it should work fine.

References :

1. Ubuntu Help

Popularity: 8% [?]