Preparing the PostgreSQL database for Spotfire

You can use either scripts or command-line commands that are provided with Spotfire Server to configure your PostgreSQL database server to store your Spotfire database. First, prepare your PostgreSQL database, and then select the best method for your system to create the Spotfire database.

About this task

If you plan to use one of the provided scripts to configure an PostgreSQL database server for storing the Spotfire database, then configure the Spotfire database before running the Spotfire Server installer.
If you plan to create a Spotfire database using the CLI command create-db, first install the Spotfire Server. For more information about this option, see Creating a Spotfire database using the command create-db.

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.

Procedure

Download and unzip the Spotfire Server installation kit from the TIBCO eDelivery web site. For instructions, see Downloading installation software.
Install the command-line database tools (for example, psql) in the system you are going to use to configure the database server.

What to do next

You can create the Spotfire database using the provided script or the command-line command create-db.