Setting up the Spotfire database (PostgreSQL)
If you plan to use a PostgreSQL server for storing the Spotfire database, then follow these steps before running the Spotfire Server installer.
About this task
PostgreSQL can be deployed on a variety of systems. Default settings
for PostgreSQL are generally suited for a smaller system. Tune the
settings to match the anticipated load before using PostgreSQL for the Spotfire
database. For example,
shared_buffers
can have a large impact on performance.
Before you begin
- Download and unzip the Spotfire Server installation kit from the TIBCO eDelivery web site. For instructions, see Downloading installation software.
- The command-line database tools (for example, psql) must be installed in the system you are going to use to configure the database server.
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.
- Linux: create_databases.sh
- Windows: create_databases.bat
What to do next
You can create the Spotfire database using one of the following strategies. Select the strategy that best suits your needs.
- 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. - 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. - 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. - Variables in create_databases (PostgreSQL)
Use these variables in the script for setting up a Spotfire database for PostgreSQL.
- 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. - 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. - 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. - Variables in create_databases (PostgreSQL)
Use these variables in the script for setting up a Spotfire database for PostgreSQL.
Parent topic: Spotfire database setup