Creating Databases

In order to use PRepS, you must create at least one PRepS database. Each database can contain as many projects as you want, and you can create as many databases as you want. Before determining how many databases, you should ask yourself the following questions:

The create_prepsdb Script

create_prepsdb [-h | -v] [-d] [-o path] [-P path] [-p path] [-u username]

The create_prepsdb script is used to create new PRepS databases. The create_prepsdb script will create the database schema, insert the default data, and setup the database owner as the default PRepS administrator for that databse.

NoteNote
 

The script will ask for an owner for the database. The user specified as the database owner must be setup as a PostgreSQL database user before this script is run.

To ensure proper operation, the create_prepsdb script must be run from the PostgreSQL super user account. The create_prepsdb script understands the following options.