Fedora Arm Secondary Architecture/Koji Database

Goal

To setup PostgreSQL for use with Koji.

Resources

• Koji Server HowTo page on Fedora wiki

Steps Performed

Create the database:

yum install postgresql-server

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

service postgresql initdb

Then start the Postgresql service with:

service postgresql start

At this point the Postgresql server is installed and operational provided no errors were reported with the database initialized. The next steps is to create a user named “koji”, set up Postgresql and populate the schema:

useradd koji
passwd -d koji
su - postgres
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

createdb -O koji koji
logout

su - koji
psql koji koji < /usr/share/doc/koji*/docs/schema.sql
exit