Difference between revisions of "Fedora Arm Secondary Architecture/Koji Database"

From CDOT Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Category:Fedora ARM Secondary Architecture]]
+
[[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://fedoraproject.org/wiki/Koji/ServerHowTo
+
* [[:fedora:Koji/ServerHowTo|Koji Server HowTo page on Fedora wiki]]
  
−
My team members and I were able for create the database as required.
+
= 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

Latest revision as of 15:21, 17 April 2010

Goal

To setup PostgreSQL for use with Koji.

Resources

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
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Fedora_Arm_Secondary_Architecture/Koji_Database&oldid=38431"