[[Category:Fedora ARM Secondary Architecture]][[Category:Winter 2010 SBR600]]= Goal =
To setup PostgreSQL for use with Koji.
The link below was very helpful in the setup of the PostgreSQL database.= Resources =
http* [[:fedora://fedoraproject.org/wiki/Koji/ServerHowTo|Koji Server HowTo page on Fedora wiki]]
My team members and I were able for create the database as required. Below is the commands executed to create that database.= Steps Performed =
root@hongkong# Create the database: yum install postgresql-server
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
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
root@hongkong# useradd kojiroot@hongkong# passwd -d kojiroot@hongkong# su - postgrespostgres@hongkong# createuser koji Shall the new role be a superuser? (y/n) nShall the new role be allowed to create databases? (y/n) nShall the new role be allowed to create more new roles?(y/n) npostgres@hongkong# createdb -O koji kojipostgres@hongkong# logoutroot@hongkong# su - kojikoji@hongkong$ psql koji koji < /usr/share/doc/koji*/docs/schema.sqlkoji@hongkong$ exitNext to be covered is editing the “/var/lib/pgsql/data/pg_hba.conf” to authorize Koji-web and Koji-Hub resources.
