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 Spotfire Download 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.