PostgreSQL

Creation of the Orchestra Database

1. Start the PostgreSQL console as the root user:

   psql -h localhost -U root -p 5432

2. Create an Orchestra database:

   CREATE DATABASE ORCHESTRA;

3. Create a user for Orchestra:

   CREATE USER ORCHESTRA WITH PASSWORD 'ORCHESTRA';

   warning

   The password of the ORCHESTRA database user should be changed for security reasons!

4. Grant all rights of the database to the user:

   GRANT ALL PRIVILEGES ON DATABASE ORCHESTRA TO ORCHESTRA;

5. Log out as the root user:

   \q

6. Log in as the Orchestra user:

   psql -h localhost -U orchestra -p 5432

7. Switch to the Orchestra database:

   \c orchestra

8. Copy the folder containing the PostgreSQL upgrade statement scripts (.../Database/Scripts/PostgreSQL) and the folder containing the statement execution script (.../Database/Scripts/PostgreSQL_Other) from the Orchestra CD to your system.

9. Adapt any path occurrences in the script install_all.sql, which can be found in the copied /PostgreSQL_Other folder. The paths must refer to the copied /PostgreSQL folder, which includes the statements.

10. Finally, invoke this script with:

    \i install_all.sql