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

From CDOT Wiki
Jump to: navigation, search
 
(2 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. Below is the commands executed to create that database.
+
= Steps Performed =
  
−
root@hongkong# yum install postgresql-server
+
Create the database:
 +
yum install postgresql-server
  
 
Once installed you will then need to initialize the Database with the following command:
 
Once installed you will then need to initialize the Database with the following command:
−
 
+
service postgresql initdb
−
root@hongkong# service postgresql initdb
 
  
 
Then start the Postgresql service with:
 
Then start the Postgresql service with:
−
 
+
service postgresql start
−
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:
 
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 koji
+
createdb -O koji koji
−
root@hongkong# passwd -d koji
+
logout
−
root@hongkong# su - postgres
+
−
postgres@hongkong# createuser koji
+
su - koji
−
 
+
psql koji koji < /usr/share/doc/koji*/docs/schema.sql
−
Shall the new role be a superuser? (y/n) n
+
exit
−
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
 
−
Next to be covered is editing the “/var/lib/pgsql/data/pg_hba.conf” to authorize Koji-web and Koji-Hub resources.
 

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"