Run the script for PostgreSQL interactively

If you are a new administrator and are creating only one Spotfire database, then this option of running the database configuration interactively, providing the values at the prompts, might best suit your scenario.

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

Run the script, and provide the values for the parameters as you are prompted.

For more information about the variables, see Variables in create_databases (PostgreSQL).

When you have provided valid values for each of the prompts, a confirmation message similar to the following example is displayed.

You have supplied the following information:
PGHOST:                          192.168.0.101
PGPORT:                          5432
DBSERVER_ADMIN_USERNAME:         postgres
DBSERVER_ADMIN_PASSWORD:         *********
PGDATABASE                       postgres
SPOTFIREDB_DBNAME:               spotfire_server_test
SPOTFIREDB_USERNAME:             test_user
SPOTFIREDB_PASSWORD:             *********

Would you like to use the above information to create the spotfire server database? [y/n]:

Press y to confirm.

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