Changes

Once installed you will then need to initialize the Database with the following command:

root@hongkong# service postgresql initdb

Then start the Postgresql service with:

root@hongkong# service postgresql start

root@hongkong# useradd koji

root@hongkong# passwd -d koji

root@hongkong# su - postgres

postgres@hongkong# createuser koji

Shall the new role be a superuser? (y/n) n

Shall the new role be allowed to create databases? (y/n) n

Shall the new role be allowed to create more new roles?(y/n) n

postgres@hongkong# createdb -O koji koji

postgres@hongkong# logout

root@hongkong# su - koji

koji@hongkong$ psql koji koji < /usr/share/doc/koji*/docs/schema.sql

koji@hongkong$ exit