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

From CDOT Wiki
Jump to: navigation, search
Line 11: Line 11:
  
 
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:
 +
  
 
root@hongkong# service postgresql initdb
 
root@hongkong# service postgresql initdb
  
 
Then start the Postgresql service with:
 
Then start the Postgresql service with:
 +
  
 
root@hongkong# service postgresql start
 
root@hongkong# service postgresql start
Line 21: Line 23:
  
 
root@hongkong# useradd koji
 
root@hongkong# useradd koji
 +
 
root@hongkong# passwd -d koji
 
root@hongkong# passwd -d koji
 +
 
root@hongkong# su - postgres
 
root@hongkong# su - postgres
 +
 
postgres@hongkong# createuser koji
 
postgres@hongkong# createuser koji
  
 
Shall the new role be a superuser? (y/n) n
 
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 databases? (y/n) n
 +
 
Shall the new role be allowed to create more new roles?(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# createdb -O koji koji
 +
 
postgres@hongkong# logout
 
postgres@hongkong# logout
 +
 
root@hongkong# su - koji
 
root@hongkong# su - koji
 +
 
koji@hongkong$ psql koji koji < /usr/share/doc/koji*/docs/schema.sql
 
koji@hongkong$ psql koji koji < /usr/share/doc/koji*/docs/schema.sql
 +
 
koji@hongkong$ exit
 
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.
 

Revision as of 14:48, 16 April 2010


The link below was very helpful in the setup of the PostgreSQL database.

http://fedoraproject.org/wiki/Koji/ServerHowTo

My team members and I were able for create the database as required. Below is the commands executed to create that database.

root@hongkong# 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:

root@hongkong# useradd koji

root@hongkong# passwd -d koji

root@hongkong# su - postgres

postgres@hongkong# 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

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