Edit the PostgreSQL create_databases script directly

If you do not want to provide the values at the prompt or create new environment variables for creating the database, then you can edit the create_databases script. Run the edited script to create the Spotfire database for PostgreSQL.

About this task

This method is suggested for backward compatibility only, for server administrators experienced with editing scripts in previous versions.

Before you begin

Complete the requirements and steps described in Preparing the PostgreSQL database for Spotfire.

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
Open the file create_databases in a text editor.
In the section under Uncomment to set variables, edit the script by providing the appropriate database server details for the variables described in Variables in create_databases (PostgreSQL)

Note: According to the PostgreSQL standards, use lower case characters for the SPOTFIREDB_DBNAME and the SPOTFIREDB_USERNAME parameters.
Save the file and close the text editor.
Open a command line as administrator, and go to the directory where you saved the scripts.
Run the appropriate create_databases command for your platform.
- Any variable for which you do not provide a value results in a prompt to provide the value, and then a confirmation message is displayed at the command-line.
- If all parameters are provided and 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.

What to do next

Install Spotfire Server

Important: The scripts contain sensitive information so remove them after your Spotfire environment is installed.