Setup PostGreSQL Ubuntu 8.10 Intrepid Ibex

With Synaptic

postgresql

• Create more covenient user. If your username is xxx:

sudo su - postgres
psql -U postgres template1
CREATE user xxx createdb createuser;
\q

Now you can directly create, delete and connect to databases.

psql -U postgres template1
CREATE user user01 createdb;
ALTER user user01 WITH password 'pass01';\q

createdb testdb