Difference between revisions of "Fedora Arm Secondary Architecture/Koji Database"
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 | ||
− |
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