Spotfire® Server and Environment - Installation and Administration

Variables in create_databases (PostgreSQL)

Use these variables in the script for setting up a Spotfire database for PostgreSQL.

Variable Description
PGHOST The name of the server running the PostgreSQL instance.
PGPORT The port that PostgreSQL should use.

Default: 5432.

PGDATABASE The name of the PostgreSQL database to connect to.

Default: postgres.

DBSERVER_ADMIN_USERNAME Name of a user with PostgreSQL database administrator privileges.

Default: postgres.

DBSERVER_ADMIN_PASSWORD Password for the DBSERVER_ADMIN_USERNAME.
SPOTFIREDB_DBNAME Name of the Spotfire Server database to create.

Default: spotfire_server.

SPOTFIREDB_USERNAME Name of the user to create to set up the Spotfire Server database.

Example: spotfire.

SPOTFIREDB_PASSWORD Password for SPOTFIREDB_USERNAME.
PSQL_PATH The path to the bin directory of the PostgreSQL command line tools.

Example: <PostregSQL installation directory>/<version>/bin.