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.
Procedure
-
Copy the
<installation files
dir>/scripts/postgres_install directory to a location where you
can open and review (and if needed, edit) the contents.
This directory contains script files that correspond to
supported platforms. The file to edit depends on your platform.
- Linux:
create_databases.sh
- Windows:
create_databases.bat
-
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.
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 Spotfire Server tables
Populating 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.