Difference between revisions of "Fedora Arm Secondary Architecture/Koji Database"
Chris Tyler (talk | contribs) |
|||
| (One intermediate revision by the same user 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. | ||
| − | + | = Resources = | |
| − | + | * [[:fedora:Koji/ServerHowTo|Koji Server HowTo page on Fedora wiki]] | |
| − | + | = Steps Performed = | |
| − | + | 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 | |
| − | |||
| − | |||
Then start the Postgresql service with: | 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: | 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 16: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
