Postgres и Ubuntu

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