Configure the Database

To configure the database in your data warehouse perform the tasks

Initialize the PostgreSQL database.
```
service postgresql-9.1 initdb
```
Start the PostgreSQL service.
```
service postgresql-9.1 start
```
Log in to the PostgreSQL server.
```
su - postgres
```
Start the PostgreSQL terminal.
```
psql
```

At the psql prompt run:

create database eucalyptus_reporting;
create user eucalyptus with password 'mypassword';
grant all on database eucalyptus_reporting to eucalyptus;
\q

Log out.
```
exit
```

Edit the /var/lib/pgsql/9.1/data/pg_hba.conf file to contain the following content:

local   all             all                                     password
host    all             all             127.0.0.1/32            password
host    all             all             ::1/128                 password

Reload the PostgreSQL service.
```
service postgresql-9.1 reload
```

Your machine is now configured as a data warehouse.