Install pgadmin 3 di Ubuntu 11.10 dan postgresql 9.1

sudo apt-add-repository ppa:flexiondotorg/postgres
sudo apt-get update
sudo apt-get install pgadmin3

After installation is complete, change user to the PostgreSQL user:

sudo su - postgres

 

You are now working as the PostgreSQL user. Now, let’s change your database password to be more robust. In this example, I’m setting the password as “s0meth1ng”:  




~$: psql -d postgres -U postgres

psql (9.1.3) Type "help" for help.

postgres=# alter user postgres with password 's0meth1ng'; ALTER ROLE

postgres=# q

 

sudo /etc/init.d/postgresql restart