[[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 = 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 Ioperational 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
