sudo apt-get install postgresql-8.2 postgresql-client-8.2 postgresql-contrib-8.2
sudo apt-get install pgadmin3
root# su - postgres
psql template1
template1=# ALTER USER postgres WITH PASSWORD ‘password’;
template1=# \q (\l list of databases)
postgres@stanley-laptop:~$ su
Password:
root@stanley-laptop:/var/lib/postgresql# passwd -d postgres
Password changed.
root@stanley-laptop:/var/lib/postgresql# su postgres -c passwd
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
