Setup PostGreSQL Ubuntu 8.10 Intrepid Ibex

Installation

With Synaptic

postgresql

Become a postgresql super user

  • 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.

Create an user for your web applications

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

Create a database

createdb testdb

Reference

To use a password:

Feedback