Use environment variables to set up the Spotfire database for PostgreSQL

If you are installing a cluster and setting up multiple database servers, then this option of creating environment variables for the Spotfire database script might best suit your installation scenario.

About this task

Perform this task before installing Spotfire Server.

Before you begin

Complete the requirements and steps described in Setting up the Spotfire database (PostgreSQL)

Procedure

Create environment variables and assign values for the script variables described in Variables in create_databases (PostgreSQL)
Open a command prompt and go to the directory where you copied the installation scripts.
At the prompt, run the script for your platform.
- Linux: create_databases.sh
- Windows: create_databases.bat
Note: Any variable for which you have specified no environment variable value results in a prompt to provide the value, and then a confirmation message is displayed.
If the parameters are correct, then a text similar to the following is displayed at the command line.
```
script_dir/postgres_install $./create_databases.sh
Press CTRL+C to stop at any time
Creating Spotfire Server database and user
Creating TIBCO Spotfire Server tables
Populating TIBCO Spotfire Server tables
----------------------------------------------------------------------------
Please review the log file (log.txt) for any errors or warnings!
```

Results

The required Spotfire user and database table schemas are created in your database.

The log file log.txt file is created in the working directory. If the execution fails, then the log file contains information about the failure. If the execution succeeds, then information about changes to the database (such as Tablespace created, User created, and so on) are reflected in the log file.

What to do next

Install Spotfire Server